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


Please Help Members By Posting Answers For Below Questions

Difference between data warehousing and olap?

653


Why do you need stage variables?

664


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1751


What are the functionalities of link collector?

627


how can we create rank using datastage?what is the meaning of rank?

8189






What is staging variable?

624


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2746


How do you generate sequence number in datastage?

625


how do u catch bad rows from OCI stage? And what CLI stands for?

2290


Name the different sorting methods in datastage.

613


What are constraints and derivations?

656


How do u convert the columns to rows in datastage?

694


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

625


Triggers,VIEW,Procedures

802


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

970