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
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
Difference between data warehousing and olap?
CHANGE CAPTURE
Can you explain how could anyone drop the index before loading the data in target in datastage?
How and where you used hash file?
What are the different plug-ins stages used in your projects?
in oracle target stage when we use load option and when we use upsert option?
What is the difference between validated and compiled in the datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Can you implement SCD2 using join, transformer and funnel stage?
How to read multiple files using a single datastage job if files have the same metadata?
What are the stages in datastage?
What are the main features of datastage?
Name the different types of Lookups in Datastage?
Explain the situation where you have applied SCD in your project?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?