When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
536What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
652In 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?
542
what is pmrep command?
what is granularity in Data ware House?
What is a mapping, session, worklet, workflow, mapplet?
Explain and compare etl & manual development?
Is apache nifi an etl tool?
how do u set partition points in the mapping?
what is the difference between cubes and package in cognos
Explain about etl data integration software?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
What is Data Vault???
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 Forward,Reverse and Re_engineering?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
what are the facilities provided by data warehouse to analytical users?