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
Describe stream connector?
What is the method of removing duplicates, without the remove duplicate stage?
What could be a data source system?
Name the different types of Lookups in Datastage?
Difference between data warehousing and olap?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is the difference between hashfile and sequential file?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Where the datastage stored his repository?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the main features of datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What is the purpose of interprocessor stage in server jobs?
What is datastage?
What is process model?