how can we send even and odd records from a sequential file
to two different targets

Answers were Sorted based on User's Feedback



how can we send even and odd records from a sequential file to two different targets..

Answer / varma

In transformer specify constraints Mod(@INROWNUM,2) =1 for Odd records and Mod(@INROWNUM,2) = 0 for even records.

Is This Answer Correct ?    41 Yes 2 No

how can we send even and odd records from a sequential file to two different targets..

Answer / subhash

SeqFile--->Transformer=====>TGTFile1,TGTFile2

1. in SeqFile, add the 'Row Number Column' property and
name it as 'Row_Number'
2. in the Transformer, give the constraint for TGTFile1
link:
'MOD(Row_Number,2)=1'----> all the ODD rows
give the constraint for TGTFile2 link:
'MOD(Row_Number,2)=0'----> all the even rows.


If we use INROWNUM in transformer, then we need to run the
transformer on 'Single' NODE configuration.

Is This Answer Correct ?    18 Yes 0 No

how can we send even and odd records from a sequential file to two different targets..

Answer / skyboyfli

Hi kiran, how can u get even or odd numbers with round robin method. i think it is not possible.

Is This Answer Correct ?    8 Yes 4 No

how can we send even and odd records from a sequential file to two different targets..

Answer / rikan

same task without using transformer stage.

Source---->column generator stage--->filter stage---->2 targets

in column generator stage, select column tab, there create
column like skey and double click on starting point of that
row,we can get the metadata ,modification window--->there we
can give cycle=1 increment by 1 and ok.write the condition
in filter stage .we can get correct out put.

Is This Answer Correct ?    5 Yes 2 No

how can we send even and odd records from a sequential file to two different targets..

Answer / vinay

HAI KIRAN, CAN U EXPLINE ME DETAIL WITH SMALL EXAMPLE

Is This Answer Correct ?    1 Yes 0 No

how can we send even and odd records from a sequential file to two different targets..

Answer / govind reddy

In Transformation level
even records-mod(empno,2=0)
odd records-mod(empno,2!=0)

Is This Answer Correct ?    2 Yes 1 No

how can we send even and odd records from a sequential file to two different targets..

Answer / satya

Create new column record number in sequential file then in
Transformer check that record number is even or odd and
send them accordingly to o/p.

Is This Answer Correct ?    1 Yes 1 No

how can we send even and odd records from a sequential file to two different targets..

Answer / chunduri

varma answer is correct

Is This Answer Correct ?    0 Yes 0 No

how can we send even and odd records from a sequential file to two different targets..

Answer / deepu

we can use transfarmer stage,in the stage create surgatekey
and write constraint like mod(<surcatekeycolumn>/2)=0 in
one link and mod(<surgatekeycolumn>/2)=1 in another link.we
get even records and odd records

Is This Answer Correct ?    0 Yes 0 No

how can we send even and odd records from a sequential file to two different targets..

Answer / kiran

by using Round Robin Partition Technique

Is This Answer Correct ?    5 Yes 14 No

Post New Answer

More Data Stage Interview Questions

How do you run datastage job from the command line?

0 Answers  


in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,


how to load meta data

2 Answers   IBM,


I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,


what is mapping lookup

1 Answers  






There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,


Differentiate between odbc and drs stage?

0 Answers  


How do u convert the columns to rows in datastage?

0 Answers  


How many types of views are there in a datastage director?

0 Answers  


Describe link sort?

0 Answers  


how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,


What are the different type of jobs in datastage?

0 Answers  


Categories