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

What is data partitioning?

1143


What are the components of ascential data stage?

1123


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2413


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1695


Differentiate between data file and descriptor file?

997


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2114


Can you define merge?

1070


What is the difference between server job and parallel jobs?

1100


What are the types of hashed files in data stage

1069


How can we improve performance of data stage jobs?

973


What are the stages in datastage?

1041


What are data elements?

1113


Differentiate between datastage and informatica?

1146


Define Job control?

1079


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2188