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 the flat file partition and where have to specify it

1 Answers   TCS,

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

What is a pre-defined event and user-defined event?

0 Answers  

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,

Explain the difference between a data warehouse and a data mart?

0 Answers  

Explain what is informatica metadata and where is it stored?

0 Answers  

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

how to duplicates from expression transformation without using sorter before that

1 Answers  

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

For more Informatica Interview Questions Click Here
Categories