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
- 13445 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shankar mahadevan
Solution algorithm
1. Sequence Generator – generate the surrogate key
2. Expresion transformation – pass the (step 1) values
3. Connect Output port of (Step 2) to all 3 dimensions
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to handle decimal places while importing a flatfile into informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
lookup transformation with screenshots
How to extract the informatica rejected data?
how many types of dimensions are available in informatica?
Is it possible to revert a global repository to local one and why?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is the -ve test case in your project.
On which transformations you created partitions in your project?
Informatica Checkpoints
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what is the size of u r source(like file or table)?
How will the document be delivered to me?
How to generate sequence numbers without using the sequence generator transformation?
