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
- 34738 Views
- IBM, iGate, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to read multiple files using a single datastage job if files have the same metadata?
What are the types of containers?
Which algorithm you used for your hashfile?
What could be a data source system?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How many areas for files does datastage have?
What is difference between symmetric multiprocessing and massive parallel processing?
What can we do with datastage director?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Can you explain repository tables in datastage?
How do you schedule or monitoring the job?
What are the functionalities of link collector?
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
Have you have ever worked in unix environment and why it is useful in datastage?
