how can we send even and odd records from a sequential file
to two different targets
- 10 Answers
- 30707 Views
- IBM, iGate, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the flow of loading data into fact & dimensional tables?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the areas of application?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is staging variable?
Name the different sorting methods in datastage.
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
in oracle target stage when we use load option and when we use upsert option?
Difference between sequential file and data set?
Define repository tables in datastage?
What is aggtorec restructure operator?
how to add a new records into source?
