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
How would you copy the content of one repository to another repository?
What do you understand by a term domain?
what is the size of u r source(like file or table)?
Can we override a native sql query within informatica?
How can we handle two sessions in informatica?
generate date / time dimension in informatica
What are the mapping parameters and mapping variables?
Scheduling properties,whats the default (sequential)
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How can we delete duplicate rows from flat files?
What is pmcmd command?
Parameter and variable differences
Explain transaction control transformation in informatica
What are the issues you have faced in your project? How did you overcome those issues?
differences between service based and product based?