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
- 6699 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 is session partitioning?
What are three tier systems in etl?
What is data modeling and data mining?
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 an ETL or ETT? And what are the different types?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
Explain etl mapping sheets?
Identifying the bottlenecks in various components of Informatica and resolving them.
what happens if the info.server doesn't find the session parameter in the parameter file?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
Teradata 
