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
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is process model?
Explain ibm infosphere information server and highlight its main features?
Define oconv () and iconv () functions in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How to Remove Duplicate using SQL?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the difference between hashfile and sequential file?
What is the purpose of interprocessor stage in server jobs?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What all are the different way to run a job?