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 / prasu

Put the transformer before the 2 tables which u have
lesscolumns.
and then add the remaning columns for the 2 tables.then
join with funnel stage

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between validated and compiled in the datastage?

703


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

663


What is "fatal error/rdbms code 3996" error?

663


what is 'reconsideration error' and how can i respond to this error and how to debug this

2121


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1631






Name the different sorting methods in datastage.

613


Define orabulk and bcp stages?

687


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

1631


Is it possible to query a hash file?

1565


Demonstrate experience in maintaining quality process standards?

1939


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2843


What are datastage sequences?

672


What is the use of datastage director?

590


Why do we use link partitioner and link collector in datastage?

685


Name the third party tools that can be used in datastage?

618