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

my source having the records like

ram 3
sam 5
tom 8

and i want to load into target like ram record 3 times,sam
record 5 times, tom record 8 times

Question Posted / chreddy6127

Answers were Sorted based on User's Feedback



my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram ..

Answer / venkatesh.malneni

let us take the metadata as name and records ok,
in expression t/r we create a new o/p port in that write the
expression as name ||''||record||''||records||''|| times


connect the newly created o/p port to the target.

Is This Answer Correct ?    2 Yes 1 No

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram ..

Answer / james

Hi Guys,

we can get the desired result set using Java t/r applying
for loop.

Please let me know if you have any suggestions.

Thanks,
James.

Is This Answer Correct ?    1 Yes 1 No

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram ..

Answer / prasad

In that case we use Normalizer transformation.
SQ--->Expression----->Normalizer----->TGT

1.Drag the ports from SQ to Expression TX.
2.In Normalizer TX we can assign the occurrences as
for ramu record define the occurrences as 3
for sam record define the occurrences as 5
for tom record define the occurrences as 8

It makes to split the record in to the desired no of times..
Hope it will work.

Please correct me if any mistakes in my answer...

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Informatica Interview Questions

define galaxy repository in informatica

0 Answers  

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

what are the row and column separations in Flat Files

3 Answers   CTS,

What are the reusable transforamtions?

2 Answers  

Briefly define a session task?

0 Answers  

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

What are the options in the target session of update strategy transsformatioin?

2 Answers  

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

Under what conditions selecting sorted input in aggregator will still not boost session performance?

0 Answers  

For more Informatica Interview Questions Click Here
Categories