Interested to Buy Any Domain ? << Click Here >> for more details...
With out using Funnel Stage, how to populate the data from
different sources to single target
- 12 Answers
- 26018 Views
- Wipro, I also Faced
- E-Mail Answers
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
Name the command line functions to import and export the DS jobs?
What are the different types of lookups in datastage?
How to reverse the string using SQL?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
options available in sequence job to run,validate?
Where the datastage stored his repository?
Is the value of staging variable stored temporarily or permanently?
Can we use target hash file as a lookup ?
What is a datastage job?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are orabulk and bcp stages?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the use of datastage director?
What is the use of datastage designer?
What is the difference between odbc and drs stage?
