Interested to Buy Any Domain ? << Click Here >> for more details...
Source flat file contains
src
---
1
2
'
'
'
18
we had 3 targets
T1 T2 T3
-- -- --
1 4 7
2 5 8
3 6 9
10 13 16
11 14 17
12 15 18
How can i get?
**Using only datastage, but not unix or any other.
I am expecting the answer soon..
Thanks in advance.
- 7 Answers
- 10331 Views
- I also Faced
- E-Mail Answers
Answer Posted / dinesh
Find MOD9 based on input data say we call as MOD
constraint in transformer
Target 1 - MOD IN 1,2,3
Target 2 - MOD IN 4,5,6
Target 3 - MOD in 7,8,0
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are sequencers?
Enlist various types of routines in datastage.
how many rows sorted in sort stage by default in server jobs
Is it possible to query a hash file?
What are the some differences between 7.x and 8.x version of datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
Is the value of staging variable stored temporarily or permanently?
What is the difference between Datastage 7.5 and 7.0?
What is the purpose of pivot stage and types of containers in datastage
What all are the different way to run a job?
Differentiate between data file and descriptor file?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Why we use surrogate key?
CHANGE CAPTURE
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
