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 |
when will use SQL override in a lookup transformation?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the data modeling tools you have used?(polaris)
what is SMP AND MPP?
Is apache nifi an etl tool?
How many steps etl contains explain with example?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
Identifying the bottlenecks in various components of Informatica and resolving them.
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.
In Which Transformation We Can Use Having Clause In Informatica?
What is grain of fact?