With out using Funnel Stage, how to populate the data from
different sources to single target
Answer Posted / venugopal
Hi Kiran,
We can populate the sources metadata to target without
using funnel stage using "Seqential File" Stage.
let me explain
In the source file path uu can mention process date and
file name with *.txt extension
For Ex:
#SRC_DATA_DIR#/JD/incoming/intermediate/*#PROC_DT#_SHIPMENT*
.txt
Above path PROC_DT is process date and SHIPMENT is file
name
Now the data can be retrieved from multiple files and
populated into a single file.
Hopes this will help you Kiran.
Any Doubts cal on 09767117168
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are the enhancements made in datastage 7.5 compare with 7.0?
How to perform incremental load in datastage?
client know skid info?
What are the functionalities of link partitioner?
What is the difference between server job and parallel jobs?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
CHANGE CAPTURE
options available in sequence job to run,validate?
What is the difference between informatica and datastage?
What are the types of views in datastage director?
What is the difference between operational data stage (ods) and data warehouse?
Where the datastage stored his repository?
Name the command line functions to import and export the DS jobs?
How do you register plug-ins?
What is the differentiate between data file and descriptor file?