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

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

3 Answers
5969 Views
Satyam, I also Faced
E-Mail Answers

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