how can we send even and odd records from a sequential file
to two different targets
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / vinay
HAI KIRAN, CAN U EXPLINE ME DETAIL WITH SMALL EXAMPLE
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
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 |
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 do you run datastage job from the command line?
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?
how to load meta data
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
what is mapping lookup
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
Differentiate between odbc and drs stage?
How do u convert the columns to rows in datastage?
How many types of views are there in a datastage director?
Describe link sort?
how to do pergformence tuning in datastage?
What are the different type of jobs in datastage?