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
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
wat are deployement groups in informatica, how it will be used for developers
How do you load first and last records into target table?
Explain constraint based loading in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the different types of transformation available in informatica.
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain in detail scd type 2 through mapping.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How to load data in informatica ?
Is there any way to read the ms excel datas directly into informatica?
can you please explain me pre session and post session options?
what is the size of u r source(like file or table)?