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
- 13338 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bharath
Hi,
in derivation for seq2 give as follows,
for file name give job parameter as file name and datatype is char..
for timestamp give Current CurrentTimestamp()
for count rows it is not not possible by using transformer
it can be achieved by adding another stage
that is aggregation stage..
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What are datastage sequences?
how do u catch bad rows from OCI stage? And what CLI stands for?
Describe the main features of datastage?
what are the errors,warnings in datastage
What are the functionalities of link collector?
Differentiate between data file and descriptor file?
To see hidden files in LINIX?
What are the primary usages of datastage tool?
What are the features of datastage flow designer?
What are the main features of datastage?
In Datastage, how you can fix the truncated data error?
Can you explain tagbatch restructure operator?
how to delete one row in target dataset
What is the project in datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
