With out using Funnel Stage, how to populate the data from
different sources to single target
- 12 Answers
- 23884 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
What are the different types of lookups in datastage?
What is the differentiate between data file and descriptor file?
Define Job control?
how to implement scd2 in datastage 7.5 with lookup stage
Differentiate between validated and Compiled in the Datastage?
What are data elements?
Distinguish between informatica & datastage. Which one would you choose and why?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can you explain tagbatch restructure operator?
What is ibm datastage flow designer?
how do u catch bad rows from OCI stage? And what CLI stands for?
How many types of hash files are there?
On which interface you will be working as a developer?
Demonstrate experience in maintaining quality process standards?
how to sort two columns in single job in datastage.
