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
Can you explain link buffering?
Different ways a project can be moved to production ?...example ….export-import and Version control.
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?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are stage variables, derivations and constants?
What are the types of jobs we have in datastage?
What is the difference between operational data stage (ods) and data warehouse?
Can you filter data in hashed file?
Differentiate between odbc and drs stage?
What are the steps required to kill the job in Datastage?
Define data aggregation?
What is the difference between Datastage 7.5 and 7.0?
sed,awk,head
What is staging variable?
What is use Array size in datastage