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
- 44058 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
What is data partitioning?
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.
Define project in datastage?
What is ibm datastage flow designer?
Have you have ever worked in unix environment and why it is useful in datastage?
how to export or import the jobs in .ISX file
What is a ds designer?
What all are the different way to run a job?
Define Merge?
How can you write parallel routines in datastage PX?
What is the difference between Datastage 7.5 and 7.0?
How a routine is called in datastage job?
What is difference between join, merge and lookup stage?
What are the different plug-ins stages used in your projects?
What is the difference between orabulk and bcp stages?
