two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
2003list and discuss two approaches for updation of target table in Informatica and how they are different.
2060you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
3 6188where are the log files generally stored.Can you change the path of the file.what can the path be?
2374what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
1 4142
where we cannot use sorter Transformation. if we use then we will not get correct data?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
What is tracing level and what are the types?
if i have a query as flat file how can we load data to target table
how many steps are there in etl process?
Explain about etl data integration software?
What is abap? What are idocs?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Explain the use lookup tables and Aggregate tables?
what are the concerns of OLTP and DSS systems?
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
Can there be sub steps of etl steps?
how do u set partition points in the mapping?
Is hadoop a etl tool?
what is a worklet?