Interested to Buy Any Domain ? << Click Here >> for more details...
how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 3249 Views
- QualTech, I also Faced
- E-Mail Answers
Answer / sajj
If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible
| Is This Answer Correct ? | 0 Yes | 0 No |
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 Relational Integrity?
What is meant by incremental load?
What is initial load and what is full load?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
what are the data modeling tools you have used?(polaris)
Compare etl & elt?
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 are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what do u do when DB time takes more?in sap bi
Explain etl?
Eliminating of duplicate records without using dynamic lookups
Teradata 
