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
- 13198 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 is aggtorec restructure operator?
What is a folder? Difference types of stages?
Differentiate between validated and Compiled in the Datastage?
Explain connectivity between datastage with datasources?
what is repositery?
Name the different sorting methods in datastage.
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
what is the use of skid in reporting?
Difference between server jobs & parallel jobs?
how to implement scd2 in datastage 7.5 with lookup stage
What are the different kinds of views available in a datastage director?
Can you explain tagbatch restructure operator?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is the difference between datastage and informatica?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
