Source and Target are flat files, Source table is as below
ID,NAME
1,X
1,X
2,Y
2,Y
On Target flat file i want the data to be loaded as
mentioned below
ID,NAME,REPEAT
1,X,2
1,X,2
2,Y,2
2,Y,2
How to achieve this, Can i get a map structure
Answers were Sorted based on User's Feedback
Answer / santa
SRC->SQ->SRT->AGG
JNR TAR
SRC->SQ->SRT->EXP->
AGG INPUT/OUPUT-> ID
AGG VARIABLE/OUTPUT->COUNT(ID)
JNR COND:- ID1=ID
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / babu
Hi Frnds,
by using aggregator we can achieve this,the mapping is have
two pipelines which is shown like bellow.
Mapping:
=======
SRC==>SQ==>EXP==>AGGR==>JNR==>TRG
|| ||
EXP1=========>
AGGR: GROUP BY ALL PORTS AND OUPUT PORT IS REPEAT=COUNT(ID)
JNR:JOIN THE TWO PIPELINES BY USING ID FROM AGGR AND EXP1 .
AGGR:
ID NAME REPEAT(OUTPUT PORT)
1 X 2
2 Y 2
JNR:ID=ID
OUTPUT OF THE JOINER IS
ID NAME REPEAT
1 X 2
1 X 2
2 Y 2
2 Y 2
TRG:
ID NAME REPEAT
1 X 2
1 X 2
2 Y 2
2 Y 2
Is This Answer Correct ? | 6 Yes | 3 No |
How to load data in informatica ?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
can we generate reports in informatica ? How?
if i have a delimited file as source so how can we seperate this file into three diff targets?
I have source like this 1:2;3. so i want to load the target as 123
What is complex mapping?
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
What does refresh system mean, and what are its distinctive choice?
What are the differences between oltp and olap?
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
is it possible to index the data in cache of lkp transformation ?