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.
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
What is the difference between account and directory options ?
What are sequencers?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the difference between informatica and datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is quality stage?
What all the types of jobs you developed?
What is datastage?
What is the difference between validated and compiled in the datastage?
Could anyone give brief explanation bout datastage admin
Describe the main features of datastage?
How and where you used hash file?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the process of killing a job in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.