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 is a router transformation?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
how many types of dimensions are available in informatica?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
what is a time dimension? give an example?
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
How we can use union transformation?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
How do you do error handling in Informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab