When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
934What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
1027In 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?
892
What is etl tool in hadoop?
Explain about the data integration suite features?
what is an ETL or ETT? And what are the different types?
how do u handle performance issues in Informatica . where can u monitor the performance ?
Explain different types of partitioning?
When do we analyze the tables? How do we do it?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What is virtual Data Warehousing?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What is grain of fact?
how do u set partition points in the mapping?
what is the difference between cubes and package in cognos
what are the types in error loging?
what is Forward,Reverse and Re_engineering?
Mention few test cases and explain them?