Hi Experts, I have a source table like this. Name Number Raj

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

Question Posted / natrajdreams

2 Answers
6759 Views
NTT Data, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi Experts, I have a source table like this. Name Number Raj 2 Ram..

Answer / rayudu

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

Hi Experts, I have a source table like this. Name Number Raj 2 Ram..

Answer / ganesh kumar

BY USING QUERY OVERRIDE IN SOURCE QUALIFIER
TO WRITE THE QUERY LIKE THIS

T_TEST UR SOURCE TABLE, NAME AND N_NUMBER UR SOURCE TABLE
COLUMN.

USING THE LEVEL PSEUDOCOLUMN TO GENERATE THE DUMMY ID(LEVEL
L)AND USING THE QUERY(DUAL TABLE) AS A INLINE VIEW AND THEN
JOIN(NON EQUIJOIN) THE CONDITION. FINALLY WE GOT THE RESUL

select t.name,t.n_number from t_test t,(select level l from
dual connect by level <= (select max(n_number) from t_test))
u where t.n_number>=u.l order by t.name;

SAME LOGIC USED FOR OTHER THAN RELATIONAL SOURCE AND THE
TRANSFORMATION.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer