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

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

What is different between the data warehouse and data mart?

0 Answers  

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

What is the difference b/w natural key and surrogate key

1 Answers  

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

what is index?how it can work in informatica

0 Answers  

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

How many repositories can we create in Informatica?

3 Answers  

For more Informatica Interview Questions Click Here
Categories