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 |
What are two types of processes that informatica runs the session?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
Define maping and sessions?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
What is a grid in Informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are limitations of joiner transformation?
What are the types of caches in lookup?
1 lac of flat fles in source how to load target at a time?
How many numbers of sessions can one group in batches?
How can you define user defied event?