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
- 13444 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
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
In warehouses how many schemas are there?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Differentiate between router and filter transformation?
What are pre and post-session shell commands?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What differs when we choose the sorted input for aggregator transformation?
What is olap (on-line analytical processing?
What are the components of workflow manager?
How many ways are there to do 'remove duplicate records in informatica'?
What is the difference between a repository server and a powerhouse?
How to update source definition?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the difference between informatics 7x and 8x and what is latest version?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
