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 this is kiran
i have one table i want divide the table with two different
table like even rows and odd rows
how can i do this one
tell me plzz

Answer Posted / eswar

oracle stage--->surrogate key generator--->transformer

the t/f having 'mod' function

mod(empkey,2)=0 --->even rows
mod(empkey,2)<>0 --->odd rows

empkey is generated from surrogate key generator

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2217


What is the command line function to import and export the ds jobs?

1132


How to read the length of word in unix?

1367


What are the different kinds of views available in a datastage director?

1018


What is the project in datastage?

1096


how to abort the job its matain duplicates?

2568


Can you filter data in hashed file?

3760


What is the purpose of pivot stage and types of containers in datastage

1028


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3158


table actions available in oracle connector?

1592


whom do you report?

1913


how to implement scd2 in datastage 7.5 with lookup stage

5592


How do you reject records in a transformer?

1108


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3325


What are transforms and what is the differenece between routines and transforms?

1043