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
- 13013 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
How one source columns or rows to be loaded in to two different tables?
Difference between data warehousing and olap?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is ibm datastage?
How will you move hashed file from one location to another location?
What are the different plug-ins stages used in your projects?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the components of datastage?
AGGREGATOR default datatype
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is process model?
Can you explain tagbatch restructure operator?
Describe stream connector?
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
