source file is having 5 records while moving into target it
want to be 10 records
Answer Posted / subbuchamala
Different ways are:
1. SRC-->COPY-->(2links)-->FUNNEL-->TGT
from copy stage get 2 copies of output data and send to funnel.
2. SRC-->Transfermer-->(2links)-->FUNNEL-->TGT
in the TFM, map the all the columns to both the links and then funnel them.
3. SRC--->TGT(with append mode)
Run job 2 times with TGT Seq file mode as "Append"
4. 2 SRCs(2 same Seq file Stages)-->Funnel-->TGT
read the same file from 2 Seqfile Stages and send them to funnel.
5. SRC--->TGT
Add 2 "File" properties in the Seq file stage and for both of them give the same file name and path.
File=directory/file.txt
File=directory/file.txt
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the various kinds of the hash file?
How to read multiple files using a single datastage job if files have the same metadata?
What could be a data source system?
What are iconv and oconv?
what is the difference between == and eq in UNIX shell scripting?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How do you import and export data into datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How to read the length of word in unix?
Differentiate between operational datastage (ods) and data warehouse?
What are the various kinds of containers available in datastage?
What are the important features of datastage?
Define data aggregation?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.