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
- 8310 Views
- IBM, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / balaji
I think they asked about architecture.
there are two types of Architecture
1. SMP ( symmetrically multi Processig )
2. MPP ( Massively Parallel processin )
| Is This Answer Correct ? | 1 Yes | 0 No |
what are the cubes developed in a sap bw project and what is the requirement for developing it?
what is the difference between date cache and lindex cache?
Is apache nifi an etl tool?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
what are the parts of Informatica server ?
what is a test load?
Explain what are the various etl tools in the market?
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
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 do you understand by the term ‘transformation’?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What is etl tool in hadoop?
Teradata 
