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 / 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 the fact table?
What is a filter transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How do you update the records with or without using update strategy?
Make a note of the quantity vaults made in informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Why update strategy and union transformations are active?
Define update strategy?
What are the different types of transformation available in informatica.
What is Cognos script editor?
How can we improve session performance in aggregator transformation?
How to do unit testing in informatica? How to load data in informatica ?
Define pmcmd command?
Different circumstance which drives informatica server to expel records?
Which means the first record should come as last record and last record should come as first record and load into the target file?