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

What are the differences between datastage and informatica?

1178


What are the processing stages?

1103


What is datastage engine?

1183


Why we use surrogate key?

1238


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

2179


Differentiate between datastage and datastage tx?

1055


What is difference between server jobs & parallel jobs?

1038


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3797


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2186


Define data aggregation?

1102


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

2369


what is the use of surogate key in datastage

2310


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2244


Can you filter data in hashed file?

3777