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
- 8431 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 data modeling?
what are the concerns of OLTP and DSS systems?
what is an ETL or ETT? And what are the different types?
Do we need an etl tool?
what are the session parameters? How do u set them?
how do u identify the changed records in operational data?
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?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
What is data modeling and data mining?
what is pmrep command?
what is the main role of FI on business
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What are the steps involved in etl process?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is the use of server?
