Interested to Buy Any Domain ? << Click Here >> for more details...
if 3 table having different columes. like first table
having 4 columns , second table having 3 columns and third
table having 2 columns then how to capture the data by
using funnel stage in parallel jobs...srinu.thadi
- 17 Answers
- 43422 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth reddy m
A.Use column generator stage for each of second and third tables for to generate extra columns as that of first table for to generate mock data and then use funnel stage finally to capture data from three tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How can you write parallel routines in datastage PX?
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 you see different stages in the designer?
Difference between in process and inter process?
what are the errors,warnings in datastage
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.
Where the datastage stored his repository?
What are the various kinds of the hash file?
What is the command line function to import and export the ds jobs?
Describe stream connector?
In Datastage, how you can fix the truncated data error?
What is the method of removing duplicates, without the remove duplicate stage?
What are the types of jobs we have in datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
