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 |
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
how do u automate Extraction process?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is the meaning of upgradation of Repository?
What are the ETL Testing Operations?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
how to load the data to fact table?
Eliminating of duplicate records without using dynamic lookups
What is Relational Integrity?
what are the concerns of OLTP and DSS systems?
Do we need an ETL tool? When do we go for the tools in the market?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?