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.
Answer Posted / 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 |
Post New Answer View All Answers
how do u set partition points in the mapping?
Explain what are the various etl tools in the market?
What is lookup table in etl testing?
Compare ETL & Manual development?
When do we go for the tools in the market?
how to load the data to fact table?
how would u estimate the size of Aggregator transform data and index cache?
what are the facilities provided by data warehouse to analytical users?
how do use session mapping parameters ?(in which transformation)
How many steps etl contains?
Define slowly changing dimensions (SCD)?
tell me few points when u become TL
What do you understand by the term ‘transformation’?
What is Data Vault???
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.