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

Can you explain link buffering?

950


Different ways a project can be moved to production ?...example ….export-import and Version control.

2217


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?

2338


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

2126


What are stage variables, derivations and constants?

946


What are the types of jobs we have in datastage?

893


What is the difference between operational data stage (ods) and data warehouse?

997


Can you filter data in hashed file?

3582


Differentiate between odbc and drs stage?

826


What are the steps required to kill the job in Datastage?

968


Define data aggregation?

889


What is the difference between Datastage 7.5 and 7.0?

895


sed,awk,head

1236


What is staging variable?

850


What is use Array size in datastage

1562