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

How can a transformation be made reusable?

0 Answers   Informatica,

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

What is source qualifier transformation?

1 Answers  

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

How the facts will be loaded? explain

2 Answers   HCL,

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

What are the transformations that are not supported in mapplet?

0 Answers  

can we use cartesian join in informatica

3 Answers   IBM,

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,

For more Informatica Interview Questions Click Here
Categories