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.
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 etl process?
what are the facilities provided by data warehouse to analytical users?
Difference between flat files and relational sources?
What is grain of fact?
Can there be sub steps of etl steps?
Eliminating of duplicate records without using dynamic lookups
what are the data modeling tools you have used?(polaris)
if i have a query as flat file how can we load data to target table
can be used COM component in Informatica ?
what is pmrep command?
Can u access a repository created in previous version of Informatica?
Explain do we need an etl tool?