Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project
Answer Posted / 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 |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is expression transformation?
How many transformations can be used in mapplets.
What is an expression transformation in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to create Target definition for flat files?
scenario where i can use only concurrent execution of workflow.
In how many ways we can create ports?
Differentiate between a repository server and a powerhouse?
What is aggregate cache in aggregator transformation?
tell me 5 session failure in real time how can you solve that in your project?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?