When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
976What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
1074In 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?
933
When do we go for the tools in the market?
what is dynamic insert?
What is a mapping?
what is the difference steps for data modeling?
What are the names of the layers in etl?
What is grain of fact?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is the difference between cubes and package in cognos
what is data modeling?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What is staging area referring to?
What is data cleaning?
Can u access a repository created in previous version of Informatica?
How many steps etl contains explain with example?
What is the difference between project backlog and product backlog?