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


Please Help Members By Posting Answers For Below Questions

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1459


What are the transformations that are not supported in mapplet?

608


What is repository manager?

543


Separate from an archive server and a powerhouse?

506


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

793






Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1943


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1707


Describe expression transformation?

640


What are the different types of olap? Give an example?

568


Explain Dataware house architecture .how data flow from intial to end?

2135


Explain how to import oracle sequence into informatica?

598


How can you validate all mappings in the repository simultaneously?

766


What is the use of an aggregator cache file?

699


Did u used latest transformations of 8.6.0? for what?

1482


How to start a workflow using pmcmd command?

719