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
Explain Quality stage?
What is difference between server jobs & parallel jobs?
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?
What is process model?
What are stage variables, derivations and constants?
Demonstrate experience in maintaining quality process standards?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
State the difference between an operational datastage and a data warehouse?
how to implement scd2 in datastage 7.5 with lookup stage
Describe link sort?
how to delete one row in target dataset
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...
what is the custome stage in datastage? how can we impliment that one? plz tell me
Lookup constraints