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 / eswar
oracle stage--->surrogate key generator--->transformer
the t/f having 'mod' function
mod(empkey,2)=0 --->even rows
mod(empkey,2)<>0 --->odd rows
empkey is generated from surrogate key generator
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain connectivity between datastage with datasources?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is difference between server jobs & parallel jobs?
What is apt_config in datastage?
Can you explain kafka connector?
What is aggtorec restructure operator?
how to sort two columns in single job in datastage.
What is the importance of the exception activity in datastage?
options available in sequence job to run,validate?
How to read the length of word in unix?
How many Key we can define in remove duplicate stage?
what is the use of materialized view?
What is process model?
table actions available in oracle connector?
project Steps,hits, Project level HArd things,Solved methods?