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
- 11381 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / phani
yes we can pass same surrogate key for 3 dimentions. bcz
three dimention are involved in same mapping. we can also
reuse the sequence generator.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is repository manager?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to load the data from a flat file into the target where the source flat file name changes daily?
Suppose we do not group by on any ports of the aggregator what will be the output?
Define mapping and session?
What is a transaction control transformation?
wf dont have integration severances how you can run?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain how many types of dimensions are available in informatica?
What is a standalone command task?
how tokens will generate?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Explain lookup transformation source types in informatica
Explain pushdown optimization $pushdownconfig parameter - informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
