Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7745 Views
- NTT Data, I also Faced
- E-Mail Answers
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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is an expression transformation?
What are the differences between a connected lookup and unconnected lookup?
Sequence generator, when you move from develoment to production how will you reset
How to do the error handling of if ur source is flatfiles?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is event and what are the tasks related to it?
How can a transformation be made reusable?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the function of aggregator transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain where to store informatica rejected data? How to extract the informatica rejected data?
what is the hint? how to use it to reduce the query processing in program?
How to extract the informatica rejected data?
what are the deliverables?in your project?
