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
- 13709 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raj
Use the Sequence and Expresion transfermations.first
genarate the surrogate with Seq trans,then send values to
exp trans,connect the exp trans o/p ports to 3 dimentions.
First Seq generate the surrogate key like 1,2,3,4,5
we wil pass this column to next tran(Exp) from there we
will connect o/p port to dimentions.so '1' wil go all
dimentions,then '2' wil go then '3' .....
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Which files are created during the session rums by informatics server?
How can you validate all mappings in the repository simultaneously?
What do you mean by enterprise data warehousing?
What are the static cache and dynamic cache in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How you can differentiate between connected lookup and unconnected lookup?
What is the difference between a connected look up and unconnected lookup?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Is it possible to create multiple domains on a single Informatica server?
Explain scd type 3 through mapping.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is the use of code page?
What differs when we choose the sorted input for aggregator transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
