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

Difference between in process and inter process?

701


what are the errors,warnings in datastage

2155


What is data partitioning?

745


What is job control?

624


What is datastage?

649






What are sequencers?

616


What are the types of containers and how to create them?

558


How to convert RGB Value to Hexadecimal values in datastage?

3458


What is the roundrobin collector?

641


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1805


What is the project in datastage?

667


Explain usage analysis in datastage?

655


How one source columns or rows to be loaded in to two different tables?

664


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2545


What is the importance of the exception activity in datastage?

625