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
- 26137 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / subhash
1. Parameterise the File name and pass the diff file names
at run time, in the target we can put write mode 'append'
2. We can add multiple 'File' properties in the seq file
stage and give them diff file names and run it.
3. If all files are in same directory, then
File: DirectoryName/*#Date#.txt
and run the job.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can you explain engine tier in information server?
describe the Steps to confiure a Qlogic switch
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Difference between server jobs & parallel jobs?
What are the difference types of stages?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Where do the datastage jobs get stored?
What is usage analysis in datastage?
What are the components of ascential data stage?
What are the job parameters?
how to add a new records into source?
Can you define merge?
What is the sortmerge collector?
What are the features of datastage flow designer?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
