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
- 42742 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
Name the different types of Lookups in Datastage?
What are datastage sequences?
Can you explain engine tier in information server?
How a routine is called in datastage job?
How many Key we can define in remove duplicate stage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the job parameters?
Can you implement SCD2 using join, transformer and funnel stage?
how to implement scd2 in datastage 7.5 with lookup stage
What is quality stage?
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 the different type of jobs in datastage?
what is the use of materialized view?
Define ds designer?
Difference between sequential file and data set?
