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 parallel processing in informatica?

1714


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641


How can we update a record in the target table without using update strategy?

1150


how tokens will generate?

2204


can anyone suggest best free Talend data integration training online

1690


Define the various join types of joiner transformation?

988


When do you use sql override in a lookup transformation?

1099


Sequence generator, when you move from develoment to production how will you reset

2040


Explain the use of aggregator cache file?

1256


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1271


how to load rows into fact table in data warehouse

1190


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7243


What is joiner change?

1148


Explain sql transformation in script mode examples in informatica

1135


How identifying bottlenecks in various components of informatica and resolving them?

1132