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 / ankita, cgi
Hi,
I have tried to get this output, i got the idea upto some
extent,
Could you please Elaborate your solution? how to get this
exact output, i.e., (10|xyz.txt|20101110 00:00:00), except
count.
Thanks in Advance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How many types of sorting methods are available in datastage?
Explain how a source file is populated?
What are the benefits of datastage?
How to reverse the string using unix?
What is process model?
What is a quality stage in datastage tool?
options available in sequence job to run,validate?
What are stage variables, derivations and constants?
How do y read Sequential file from job control?
how to abort the job its matain duplicates?
What are the components of datastage?
Is the value of staging variable stored temporarily or permanently?
What are the partitioning techniques available in link partitioner?
Define meta stage?