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
- 13517 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sumana
Hi i have a samll doubt on this
Three dimensions are in same mapping but three different
flows. 3 diffrent flows means when the first completes then
only the second flow will start in this case by use one
sequence generator how will we pass the same values to all
the three dimensions. The surrogate key value should pass
like this for all the dimensions
dim1 dim2 dim3
---- ---- -----
1 1 1
2 2 2
3 3 3
4 4 4
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a filter transformation and why it is an active one?
What is the need of an ETL tool?
What are the tuning techniques you applied during your last project
What is Index Caches size?
What is union transformation in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the differences between joiner transformation and source qualifier transformation?
Can anyone tell me the new features in Informatica 9 Version?
How can we improve session performance in aggregator transformation?
In which transformation you cannot drag ports into it?
Enlist the tasks for which source qualifier transformation is used.
Mention few power centre client applications with their basic purpose?
What is workflow monitor?
Which are the different editions of informatica powercenter that are available?
How to do unit testing in informatica?
