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 a input as:

Col
1
1
2
2
3

I want 3 output as:

Output1:

1
1

Output2:

2
2

Output3:

3

i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

Answer Posted / narayan

just add the mod function like this =MOD(inputcol|3) and then load into different targets

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

root tree will find which is server job and which is parallel job?

1963


Explain how a source file is populated?

1359


What are some prerequisites for datastage?

1092


What are constraints and derivations?

1164


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2439


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2481


whom do you report?

1921


what are the errors,warnings in datastage

2689


What is the difference between passive stage and active stage?

1523


Can you explain players in datastage?

1185


What is a merge?

1156


What are the differences between datastage and informatica?

1170


How can we improve the performance in datastage?

1097


What is datastage?

1077


What are data elements?

1165