can u anyone plz share some etl testing interview question .
and share the sql queries and unix .
plz help me to clear in the etl testing interview by sharing ur knowledge
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Difference between flat files and relational sources?
what is session partitioning?
Identifying the bottlenecks in various components of Informatica and resolving them.
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?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what is granularity in Data ware House?
Eliminating of duplicate records without using dynamic lookups
what are the different Reporting and ETL tools available in the market?
SCD2 will work on only dimension tables as well as fact Table?
What is abap? What are idocs?
Two default user groups created in the repository are____and_____.