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
- 8550 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 is abap? What are idocs?
What are the key benefits of ETL Testing?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Do we need an ETL tool? When do we go for the tools in the market?
What is fact? What are the types of facts?
What do you understand by the term ‘transformation’?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What are the steps involved in etl process?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
Explain about round-robi?
What is etl process? How many steps etl contains?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how does the server recongnise the source and target databases.Elaborate on this
What are three tier systems in etl?
What is data cleaning?
