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
- 13554 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
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain about Informatica server process that how it works relates to mapping variables?
Mention some types of transformation?
Explain pmcmd command usage in informatica
What is the use of target designer?
Differentiate between a database and data warehouse?
How to join three sources using joiner?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the function of aggregator transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the different ways to implement parallel processing in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
State the differences between sql override and lookup override?
whats the logic to load the lower level of granularity of data to fact table.
