how can one come to know wether the records loak into the
target if we use update strategy
What is facttable granularity?
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 can run the wf through pmcmd commend? write script?
How to recover sessions in concurrent batches?
Differentiate between source qualifier and filter transformation?
When do you use sql override in a lookup transformation?
What is router transformation
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
Clarify the utilization of aggregator cache record?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
Explain the types of transformations?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?