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
- 13337 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / akila
Pass the name of the file in a parameter, say p1.If your
count of rows flowing through the transformer is not huge,
the run the transformer in sequential stage and pass
@INROWNUM:'|':p1:'|':DSJobStartTimeStamp as a value of a
field. Add a tail stage in between the transformer and the
2nd file. In the tail stage, input 1 as the count of
records.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Which algorithm you used for your hashfile?
Can you explain engine tier in information server?
What are the functionalities of link partitioner?
What is the importance of the exception activity in datastage?
What is usage analysis in datastage?
Explain how a source file is populated?
Give an idea of system variables.
How and where you used hash file?
in oracle target stage when we use load option and when we use upsert option?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How many types of stage?
What are constraints and derivations?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Triggers,VIEW,Procedures
