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
- 13190 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
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Explain ibm infosphere information server and highlight its main features?
What is the difference between operational data stage (ods) and data warehouse?
How one source columns or rows to be loaded in to two different tables?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the functionalities of link partitioner?
how to implement scd2 in datastage 7.5 with lookup stage
Can you implement SCD2 using join, transformer and funnel stage?
What is a datastage job?
Describe stream connector?
On which Dimension Table you implemented SCD Type in your Project
What is oci?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are transforms and what is the differenece between routines and transforms?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
