In a mapping i have three dimensions. If i want to pass a
same surrogate key value to all the three dimensions by
using one sequence generator is possible?If the mapping is
containing single flow? And in the same case if the mapping
is contaning 3 flows for the three dimensions then by using
one sequence generator can we populate surrogate key (same
value) to all the three dimensions?
Answer Posted / abhishek
yes offcourse we can do it
for understandi this you can refer SCD2 version it haapens
same like ur qustion
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
tell me the rules and responsblites in our project(my project is development)
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain what are the different versions of informatica?
How to configure mapping in informatica?
How to partition the Session?
What are the different ways to implement parallel processing in informatica?
Explain in detail about scd type 1 through mapping.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the different components of powercenter?
What is a repository manager?
What is target load order?
How would you copy the content of one repository to another repository?
what is index?how it can work in informatica