Interested to Buy Any Domain ? << Click Here >> for more details...
hi All,
i have one scenario like if
source--->transformer-->2 target sequential files
the 1 st target sequential file is loads the data from
source
and 2nd target sequntial file contain the 1st target total
record count,and file name of 1 st target seq file and
timestamp seperated by delimeter
for example if source have 10 record the 1st target seq
file hav 10 records
and
2nd target seq file example
10|xyz.txt|20101110 00:00:00
could you please help me out how can i implement in
datastage job.
- 4 Answers
- 12977 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / akila
Pass the name of the file in a parameter, say p1.If your
count of rows flowing through the transformer is not huge,
the run the transformer in sequential stage and pass
@INROWNUM:'|':p1:'|':DSJobStartTimeStamp as a value of a
field. Add a tail stage in between the transformer and the
2nd file. In the tail stage, input 1 as the count of
records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is the importance of the exception activity in datastage?
What are routines in datastage?
Can you explain players in datastage?
What are the different common services in datastage?
How do you reject records in a transformer?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the types of hashed files in data stage
Why do we use exception activity in Datastage?
What is the difference between datastage and datastage tx?
What is difference between join, merge and lookup stage?
What is a ds designer?
On which interface you will be working as a developer?
What is a datastage job?
How many Key we can define in remove duplicate stage?
