Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 6 Answers
- 13463 Views
- IBM, I also Faced
- E-Mail Answers
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
Can u generate reports in Informatica?
How does a sorter cache works?
Mention few power centre client applications with their basic purpose?
What are the types of lookup transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How many dimensions are there in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How you can differentiate between connected lookup and unconnected lookup?
What is expression transformation?
Which files are created during the session rums by informatics server?
design of staging area?
How to update source definition?
