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
- 40841 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 are the different options associated with dsjob command?
What are stage variables?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the purpose of interprocessor stage in server jobs?
Nls stands for what in datastage?
Which algorithm you used for your hashfile?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are routines in datastage?
What are transforms and what is the differenece between routines and transforms?
What is oci?
How to read multiple files using a single datastage job if files have the same metadata?
Explain how a source file is populated?
What all the types of jobs you developed?
On which Dimension Table you implemented SCD Type in your Project
What are the repository tables in datastage?
