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
How to reverse the string using unix?
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...
how to add a new records into source?
Explain usage analysis in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the functionalities of link partitioner?
Define ds designer?
What are the components of ascential data stage?
What is aggtorec restructure operator?
which r the connectors used in san?
AGGREGATOR default datatype
How to find value from a column in a dataset?
How a source file is populated?