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
- 25548 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
What is a merge?
What are the types of jobs we have in datastage?
What are the types of views in datastage director?
Explain ibm infosphere information server and highlight its main features?
What are constraints and derivations?
Define project in datastage?
Define data aggregation?
How to find value from a column in a dataset?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the components of datastage?
How many types of sorting methods are available in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are iconv and oconv?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
