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 / srinu

sourc->transformer->filter->two targets
in the transformer stage we have append new column and
derviation area write mod(@outrownum,2) (where @outrownum in
sysvarible)
after that we put fileter or switch in that
write condition on append column 0 then even records
1 then go odd records

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between odbc and drs stage?

1100


Where do you see different stages in the designer?

1104


What is datastage?

1094


What are the types of jobs we have in datastage?

1077


Name the third party tools that can be used in datastage?

1089


What is the difference between the local container and shared container?

1112


How rejected rows are managed in datastage?

1527


What is a ds designer?

1075


What are stage variables and constants?

1154


What is a quality stage in datastage tool?

1088


Explain Quality stage?

1162


How do you import and export data into datastage?

1247


Name the different types of Lookups in Datastage?

1271


what are the errors,warnings in datastage

2709


Describe the main features of datastage?

1085