Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / rath.santaprasanna1983

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

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

How to load a Dimension ? and how to load a fact table?

0 Answers  

What is informatica?

0 Answers  

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

How to extract sap data using informatica?

0 Answers  

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

Where are the source flat files kept before running the session?

0 Answers   Informatica,

What are the data movement modes in informatcia?

1 Answers  

For more Informatica Interview Questions Click Here
Categories