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
- 13188 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
What are the components of datastage?
Is possible to create skid in dim,fact tables?
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 difference between operational data stage (ods) and data warehouse?
sed,awk,head
Differentiate between datastage and datastage tx?
What are stage variables, derivations and constants?
Explain usage analysis in datastage?
What is datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How many types of stage?
Why do we use exception activity in Datastage?
how to add a new records into source?
Define data aggregation?
How to reverse the string using SQL?
