Interested to Buy Any Domain ? << Click Here >> for more details...
what is architecture of your datastage project???
i came across this question many times in interviews in specific what can i answer
plz help me.
- 2 Answers
- 8315 Views
- IBM, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
we can say like there is a staging area to store the data in the form of tables, and then it transforms to ETL stage (Here we will do all the conversions,remove duplicates,joining,merging etc) then dimension load and fact load from that we load to production and then to maintainance
0.different source of inputs
1.staging area
2.ETL Transform stage
3.Dimension and Fact load
4.EDW
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are three tier systems in etl?
can cubes contain measures ?
Explain the difference between etl tool and olap tools?
what are the concerns of OLTP and DSS systems?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
flat filevalidation in informatica
what are the production issues in datastage?
What is partitioning? Explain different types of partitioning?
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 are the names of the layers in etl?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
how to connect to a flatfile through ftp in informatica
what is pmrep command?
Explain do we need an etl tool? When do we go for the tools in the market?
how to load the data to fact table?
