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
- 13058 Views
- IBM, I also Faced
- E-Mail Answers
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
How do you start developing a datastage project?
What is difference between join, merge and lookup stage?
What is the difference between validated and compiled in the datastage?
How to Remove Duplicate using SQL?
What is size of a transaction and an array means in a datastage?
Differentiate between data file and descriptor file?
What is the method of removing duplicates, without the remove duplicate stage?
What are system variables and sequencers in datastage
What is quality stage?
What are the components of datastage?
How do you import and export data into datastage?
what is the use of materialized view?
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
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the different type of jobs in datastage?
