1)Source file contains one record, I want 100 records in
target file.
Answer Posted / subhash
Another best way is:
SRC--->TFM--->TGT
in TFM, we can do this by using LOOPing concept.
@ITERATION<=100
map the SRC record to TGT.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the difference types of stages?
What are constraints and derivations?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is merge stage?
What is the differentiate between data file and descriptor file?
Can you filter data in hashed file?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the difference between datastage and informatica?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Differentiate between operational datastage (ods) and data warehouse?
What are the different types of lookups in datastage?
What is the purpose of interprocessor stage in server jobs?