Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

Describe expression transformation?

1108


What are some examples of informatica etl programs?

914


What is a difference between complete, stop and abort?

1066


Define joiner transformation?

1027


How are the sources and targets definitions imported in informatica designer?

1086


How many number of sessions can one group in batches?

1137


Different circumstance which drives informatica server to expel records?

957


What is dimensional table?

1043


How do you remove duplicate records in informatica? And how many ways are there to do it?

1149


How to update source definition?

1070


What is sq transformation?

1137


Why update strategy and union transformations are active? Explain with examples.

1215


difference between informatica 8.1.1 and 8.6

3658


What is primary and backup node?

1110


What are active transformations.

1634