Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project
Answers were Sorted based on User's Feedback
Answer / davankumar
Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / davankumar
Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain sessions. Explain how batches are used to combine executions?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
Enlist the advantages of informatica.
COM components can be used in Informatica
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
What are the new features of informatica 9.x at the developer level?
What is target designer and target load order?
expain about the tune parameters?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
Explain one complecated mapping?
What is the use of incremental aggregation?
Can you use flat files in Mapplets.