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 the benefit of partitioning a session?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
how to return multiple columes through through un-connect lookup?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
Explain transaction control transformation in informatica
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
How many mapplets u have created? and what is the logic used
How to import oracle sequence into Informatica?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is a sorter transformation?
In operator is used in which transformation in informatica 8.6.0