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

explain about unit testing? in real time?

0 Answers   L&T,

What are the types of data warehouses?

0 Answers   Informatica,

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

What will be the approach?

0 Answers  

in which situations do u go for scds ?

3 Answers   TCS,

enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

What is an aggregator transformation?

0 Answers  

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

What is the function of aggregator transformation?

0 Answers  

where to store informatica rejected data?

0 Answers  

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

For more Informatica Interview Questions Click Here
Categories