where we use column generator stage in real time scenario?

Answer Posted / ram

The Column Generator stage adds columns to incoming data
and generates mock data for these columns for each data row
processed. The new data set is then output..

Let us two table x and Y ..and you are doing funnel..
X file is having only 2 columns and Y file is having 3
columns..
While doing funnel metadata should be same. in order to
achieve this include one column to X file and next use this
column generator stage, this stage populates some mock data
in third column..

Is This Answer Correct ?    37 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can one find bugs in job sequence?

891


What are the repository tables in datastage?

927


What are the types of containers and how to create them?

645


What is the use of datastage director?

677


How rejected rows are managed in datastage?

1031






How do you import and export data into datastage?

796


What are the different common services in datastage?

826


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2136


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?

1133


What are orabulk and bcp stages?

738


What are the enhancements made in datastage 7.5 compare with 7.0?

803


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

751


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2810


Define Job control?

759


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2541