When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
932What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
1026In 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?
890
how do use session mapping parameters ?(in which transformation)
what are the concerns of OLTP and DSS systems?
What are dimensions?
Explain do we need an etl tool?
what are the types in error loging?
What is a mapping?
How to delete data which is not in source table?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
how would u estimate the size of Aggregator transform data and index cache?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
what is the difference steps for data modeling?
how many steps are there in etl process?
how does the server recongnise the source and target databases.Elaborate on this
how do u extract data from different data sources explain with an example?
Identifying the bottlenecks in various components of Informatica and resolving them.