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 is the difference between hashfile and sequential file?
how can we create rank using datastage?what is the meaning of rank?
What are the primary usages of datastage tool?
How do you reject records in a transformer?
What is the difference between an operational datastage and a data warehouse?
How to reverse the string using unix?
Explain usage analysis in datastage?
What are some different alternative commands associated with "dsjob"?
What are the various kinds of the hash file?
options available in sequence job to run,validate?
How and where you used hash file?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How to reverse the string using SQL?
What is the use of hoursfromtime() function in transformer stage in datastage?
project Steps,hits, Project level HArd things,Solved methods?