Hi we can achive like this Source--->Transformer---->filter--->

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

Question Posted / farzana kalluri

4 Answers
8817 Views
I also Faced
E-Mail Answers

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 server jobs & parallel jobs?

1024

Explain entity, attribute and relationship in datastage?

1053

What could be a data source system?

954

How do u convert the columns to rows in datastage?

1147

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3275

How complex jobs are implemented in datstage to improve performance?

973

How do you remove duplicate values in datastage?

1105

What is a folder? Difference types of stages?

1112

EXPLAIN SCD

1345

How and where you used hash file?

1117

Notification Activity

1358

What are sequencers?

1068

How a source file is populated?

1021

What are the types of views in datastage director?

1724

What is the difference between account and directory options ?

1121