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
- 34826 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 |
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
Can you explain link buffering?
What is the default execution order of the sequential file?
What all the types of jobs you developed?
What can we do with datastage director?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
root tree will find which is server job and which is parallel job?
Explain entity, attribute and relationship in datastage?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
how will u design file watch jobs?
Teradata 
