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
Terminate Activity
What is the purpose of pivot stage?
Define Merge?
How to reverse the string using unix?
What are stage variables, derivations and constants?
What are some prerequisites for datastage?
State the difference between an operational datastage and a data warehouse?
What is aggtorec restructure operator?
How you Implemented SCD Type 1 & Type 2 in your project?
How the ipc stage work?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are stage variables?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is apt_config in datastage?
Which algorithm you used for your hashfile?