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
- 13159 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
Describe routines in datastage? Enlist various types of routines.
What is a quality stage in datastage tool?
Can you explain kafka connector?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the types of hashed files in data stage
what are the errors,warnings in datastage
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How the ipc stage work?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How do you schedule or monitoring the job?
How do you remove duplicate values in datastage?
What are the partitioning techniques available in link partitioner?
What is the difference between passive stage and active stage?
How to perform incremental load in datastage?
