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 Posted / 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 |
Post New Answer View All Answers
Describe expression transformation?
What are some examples of informatica etl programs?
What is a difference between complete, stop and abort?
Define joiner transformation?
How are the sources and targets definitions imported in informatica designer?
How many number of sessions can one group in batches?
Different circumstance which drives informatica server to expel records?
What is dimensional table?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to update source definition?
What is sq transformation?
Why update strategy and union transformations are active? Explain with examples.
difference between informatica 8.1.1 and 8.6
What is primary and backup node?
What are active transformations.