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

why do u need the IOS upgradation in a FC switch

2057


What are stage variables, derivations and constants?

916


What are the different common services in datastage?

983


What is the use of hoursfromtime() function in transformer stage in datastage?

813


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1978


Nls stands for what in datastage?

960


Difference between server jobs & parallel jobs?

860


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

855


What are the areas of application?

912


Define repository tables in datastage?

913


How do you start developing a datastage project?

859


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2035


What are the processing stages?

856


How do you reject records in a transformer?

857


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

1975