Explain and compare etl & manual development?
No Answer is Posted For this Question
Be the First to Post Answer
What is a staging area? What is the purpose of a staging area?
Two default user groups created in the repository are____and_____.
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?
what is different between sequential batch and concurrent batch and which is recommended and why?
What is a mapping, session, worklet, workflow, mapplet?
Which transformation we use to convert 'NA' to 'Not Available'
what are Lookup caches options? Including persistent caches.
Identifying the bottlenecks in various components of Informatica and resolving them.
what is the difference between cardinality and Nullability?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
When do we go for the tools in the market?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.