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 benefits of datastage?
What is a ds designer?
What is difference between join, merge and lookup stage?
On which Dimension Table you implemented SCD Type in your Project
What is merge stage?
What is the difference between hashfile and sequential file?
How we can covert server job to a parallel job?
project Steps,hits, Project level HArd things,Solved methods?
Name the different types of Lookups in Datastage?
Explain datastage architecture?
Where do the datastage jobs get stored?
How rejected rows are managed in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the difference between datastage and datastage tx?
Differentiate between datastage and datastage tx?