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
- 8447 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 facilities provided by data warehouse to analytical users?
what is Forward,Reverse and Re_engineering?
where we cannot use sorter Transformation. if we use then we will not get correct data?
what is pmrep command?
Explain about hash partitioning?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
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.
what is meant by drill through?(Mascot)
What is etl tool in hadoop?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
list and discuss two approaches for updation of target table in Informatica and how they are different.
explain the methodology of Data Warehousing?(Polaries)
Teradata 
