How many steps etl contains?
No Answer is Posted For this Question
Be the First to Post Answer
What do you understand by the term ‘transformation’?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
State the differences between shortcut and reusable transformation
what is session partitioning?
dimension object created in oracle can be imported in designer?how?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What are the differences between sql override and update override?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what are Lookup caches options? Including persistent caches.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?