Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project
- 2 Answers
- 7771 Views
- iGate, Qualcomm, I also Faced
- E-Mail Answers
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
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the data movement modes in informatica?
How is union transformation utilized?
permutations of mapplet
What is informatica worklet?
State the limitations where we cannot use joiner in the mapping pipeline?
How to elaborate tracing level?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the format of informatica objects in a repository?
What is expression transformation?
What is the benefit of partitioning a session?
Explain pushdown optimization $pushdownconfig parameter - informatica
Differentiate between router and filter transformation?
What is meant by lookup transformation?
