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...

I HAVE 10 records in source. I want to store i record in
target 1, second record in target 2, third record in target
3, 4 th record again in target 11, 5th again in target 2,
6th again in target3 etc.... how it is possible?

Answer Posted / gyana

source--->sq--->attached a sequence generator with settings

current value=1
start value=1
end value=3
incrimented by=1
cycle=yes

------->router(3groups)--->3 targets

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by query override?

1043


What is the use of code page?

1068


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8206


What are the modules in Power Center

1666


What are the limitations of joiner transformation?

1091


What is update strategy transform?

1078


What is a connected transformation?

1096


Define enterprise data warehousing?

1183


How do you load unique records into one target table and duplicate records into a different target table?

1205


What are the different clients of powercenter?

1040


How do you convert single row from source into three rows into target?

1137


Write the unconnected lookup syntax and how to return more than one column.

1097


what is Active lock explain

2772


How would you copy the content of one repository to another repository?

995


How to update or delete the rows in a target, which do not have key fields?

1166