how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
Post New Answer View All Answers
Explain what is etl process? How many steps etl contains explain with example?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
How many types of transformations supported by sorted input?
where is the cache (lookup, index) created and how can you see it.
what are the types in error loging?
Explain about the data integration suite features?
what do u do when DB time takes more?in sap bi
Explain the difference between etl tool and olap tools?
Mention few test cases and explain them?
What is virtual Data Warehousing?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
what is an ETL or ETT? And what are the different types?
What are materialized views & where do we use them?
What is etl process? How many steps etl contains?
what is pmrep command?