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 / farzana kalluri

Hi we can achive like this

Source--->Transformer---->filter--->2 targets

Transformer--->1.constraints--->mod(input,2)=0

2.constraint---->mod(input,2)=1
From this we can get the odd numbers in one target and
even numbers in one target...

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain Quality stage?

1087


What is difference between server jobs & parallel jobs?

986


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2549


What is process model?

1919


What are stage variables, derivations and constants?

1164


Demonstrate experience in maintaining quality process standards?

2456


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2820


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

2382


State the difference between an operational datastage and a data warehouse?

1055


how to implement scd2 in datastage 7.5 with lookup stage

5549


Describe link sort?

959


how to delete one row in target dataset

3061


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4137


what is the custome stage in datastage? how can we impliment that one? plz tell me

2315


Lookup constraints

1200