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 / uzval_vee
u can pass same surrogate key to three dimensions ,this is
possible in case 2 i.e 3 flows,according to my view
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the tasks that source qualifier perform?
What are the different types of olap? Give an example?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is Cognos script editor?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the advantages of informatica?
how many types of dimensions are available in informatica?
Why do we need informatica?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What does cheating measurement mean?
Mention some types of transformation?
What are connected or unconnected transformations?
what is degenerated dimension?
How are indexes created after completing the load process?
When do you use sql override in a lookup transformation?