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
- 13015 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 the features of datastage flow designer?
What are the benefits of datastage?
Which algorithm you used for your hashfile?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Explain entity, attribute and relationship in datastage?
What are the components of ascential data stage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the components of datastage?
Define orabulk and bcp stages?
What are the some differences between 7.x and 8.x version of datastage?
Explain connectivity between datastage with datasources?
Differentiate between datastage and datastage tx?
how to add a new records into source?
what is repositery?
