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
- 13163 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
Why fact table is in normal form?
What is difference between server jobs & parallel jobs?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what is the use of surogate key in datastage
How do you generate sequence number in datastage?
State the difference between an operational datastage and a data warehouse?
What are the processing stages?
What is merge stage?
What are the functionalities of link partitioner?
What are the types of containers and how to create them?
How can we improve performance of data stage jobs?
What is a merge in datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Different ways a project can be moved to production ?...example ….export-import and Version control.
How do you start developing a datastage project?
