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

What are the different lookup cache(s)?

0 Answers  

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

Slowly changing dimensions, types and where will you use them

0 Answers  

what is the monster dimension plz give me one example

2 Answers   EDS,

What are batches?

0 Answers  

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

Explain joiner transformation in informatica

0 Answers   Informatica,

How many ways you create ports?

1 Answers  

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

For more Informatica Interview Questions Click Here
Categories