Interested to Buy Any Domain ? << Click Here >> for more details...
how can we send even and odd records from a sequential file
to two different targets
- 10 Answers
- 34317 Views
- IBM, iGate, TCS, I also Faced
- E-Mail Answers
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 |
What is the difference between server job and parallel jobs?
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
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
How to reverse the string using unix?
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
how to call routines in stages?
how can we do null handling in sequential files
What is job control?
Hi Vijay here For Four CPU's how many nodes will required?
How the ipc stage work?
can any one tell me how to install datastage 8.1 in windows xp with wizard
Teradata 
