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.
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
If you want to use the same piece of code in different jobs, how will you achieve it?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
what is the use of skid in reporting?
What is the difference between account and directory options ?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how to abort the job its matain duplicates?
What are the types of jobs we have in datastage?
What is quality stage?
What is the flow of loading data into fact & dimensional tables?
What are the repository tables in datastage?
On which Dimension Table you implemented SCD Type in your Project
Can you highlight the main features of ibm infosphere information server?
What is a quality stage in datastage tool?
Can you implement SCD2 using join, transformer and funnel stage?
Can you explain engine tier in information server?