Can we get 1st record through Informatica(without sequence number).
No Answer is Posted For this Question
Be the First to Post Answer
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
tell me the informatica architecture
Informatica and datawarehousing courses in Pune?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
What are the uses of etl tools?
How do you implement unconn. Stored proc. In a mapping?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Can we update a target table (without primarykey) by using update strategy transformation?
What do think which one is the better joiner or look up?
Differentiate between a database and data warehouse?
What are the differences between oltp and olap?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?