Define error Threshold?
What is rank transformation?
If I am having 6 flat files in data. How can you load the data at a time
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to load last 10 records of flat file in to the target?
How are the sources and targets definitions imported in informatica designer?
In any project how many mappings they will use(minimum)?
Define the various join types of joiner transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
what is the flat file partition and where have to specify it
What is the scenario which compels informatica server to reject files?