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


Please Help Members By Posting Answers For Below Questions

Describe stream connector?

1053


What is the method of removing duplicates, without the remove duplicate stage?

783


What could be a data source system?

763


Name the different types of Lookups in Datastage?

996


Difference between data warehousing and olap?

833


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

3525


What is the difference between hashfile and sequential file?

951


Different ways a project can be moved to production ?...example ….export-import and Version control.

2195


Where the datastage stored his repository?

800


What is the use of hoursfromtime() function in transformer stage in datastage?

813


What are the main features of datastage?

917


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2931


What is the purpose of interprocessor stage in server jobs?

1965


What is datastage?

858


What is process model?

1747