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



Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target f..

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

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target f..

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

Post New Answer

More Informatica Interview Questions

How to load data in informatica ?

0 Answers  


How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  


can we generate reports in informatica ? How?

3 Answers  


if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,


I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,






What is complex mapping?

0 Answers  


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?

1 Answers  


What does refresh system mean, and what are its distinctive choice?

0 Answers  


What are the differences between oltp and olap?

0 Answers  


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?

3 Answers   Syntel,


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

1 Answers  


is it possible to index the data in cache of lkp transformation ?

0 Answers  


Categories