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
- 13331 Views
- IBM, I also Faced
- E-Mail Answers
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
Name the third party tools that can be used in datastage?
Define oconv () and iconv () functions in datastage?
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
Define ds designer?
What is the importance of the exception activity in datastage?
What are stage variables and constants?
Differentiate between odbc and drs stage?
What is quality stage?
What is difference between server jobs & parallel jobs?
How do you schedule or monitoring the job?
What are the repository tables in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How a routine is called in datastage job?
why do u need the IOS upgradation in a FC switch
