rayudu


{ City }
< Country > india
* Profession *
User No # 85788
Total Questions Posted # 0
Total Answers Posted # 18

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 132
Users Marked my Answers as Wrong # 19
Answers / { rayudu }

Question { NTT Data, 6780 }

Hi Experts,

I have a source table like this.

Name Number
Raj 2
Ram 1
Sam 2
John 1


In the target I need the ouptput like the below

Raj
Raj
Ram
Sam
Sam
John

We dont know the number value . It will be changing as n..

Please help me regarding this.


Thanks,
Nataraj V


Answer

Hi,

It can be done using Java Transformation.

In Java Code tab write the below code.

itr=in_number;

for(i=1;i<=itr;i++)
{
o_name=in_name;
generaterow();

}




Regatds,
Rayudu

Is This Answer Correct ?    7 Yes 0 No

Question { 4009 }

Hi I'm new in Informatica.
Can you show me a mapping sample on how to piviot the records?

Thanks
Robin


Answer

can you precisely tell me your requirement becoz we have
multiple ways to pivot the data

Is This Answer Correct ?    0 Yes 0 No


Question { Accenture, 7816 }

My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….


Answer

HI ,I think there is no need of sequence generator .

sq->exp->tg1
->tg2
In exp take 2 port

out_1=input_port*10
out_2=input_(port*10)+1.

Link out_1 to tgt1
Link out_2 to tgt2.

Is This Answer Correct ?    14 Yes 0 No

Prev    1    [2]