Informatica and Netezza notes

------- Informatica-------
-I was mostly working with creating mapping and validating it.
1. check if the informatica services are running,any session failed or not,if a file failed then how many records loaded and how many not loaded yet and figure out how to load rest,also find out the reason for session failure.
2. how to use refreshinterval for incremental loads in tables using informatica?
- What to do if session fails, what to if mapping it wrong OR work flow is wrong.
- how to recover the lost records, do we reinitiate the process or only work to load the remaining records.
- whom to contact if session, workflow, mapping falis.
http://etl-developer.com/2011/12/email-task-session-and-workflow-notification-informatica/#Workflow-and-session-details
- do we raised some tickets? what tool used? ZEONSS tool.
2- What do we used for work flow management in hdfs. ozzie or another tool.
3 - Develop informatica mappings and workflows for new change requests.
what is the process after mapping or workflow creation was done?
what database usually you used in informatica?
4- Optimise the current mappings and workflows?
5 -Ensure daily repository backup is taken.
6 - Follow SLA
-Develop mappings and workflows as per provided requirements.
-Create high level and low level docs for the mappings created.
-Test those mappings and prepare test cases,also ask for peer review and create doc for same.
-Send daily updates to customer.
------------------------------What are you doing ------------------------------------------
Very limited exposure to Netezza. Since I got more passionated to hadoop I started working in that. But I would welcome any opportunity to work with it.

- Informtica, Star schmema, snow flakes schema, elastic search, EMR, RedShift, S3, Oracle analytical queries.