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

When do you use mapping parameters? (In which transformations)

1 Answers  

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,

What are mapplets?

0 Answers  

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

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

0 Answers   TCS,

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

For more Informatica Interview Questions Click Here
Categories