where we use column generator stage in real time scenario?

Answers were Sorted based on User's Feedback



where we use column generator stage in real time scenario?..

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

where we use column generator stage in real time scenario?..

Answer / kiran

Hai This is Kiran.

if u want to add one mmore column in target while populate
data from source to taget.

Thaks&Regards
Kiran Kumar M.
(9393363309)

Is This Answer Correct ?    19 Yes 0 No

where we use column generator stage in real time scenario?..

Answer / vishwanath

Suppose consider a situation wherein u need to join two
tables A and B but u don hve a same key column in both the
tables. U can use column generator for generating a DUMMY
column (key column) and perform joining.

Is This Answer Correct ?    9 Yes 0 No

where we use column generator stage in real time scenario?..

Answer / yarramasu

If u have two tables that are a and b. A table have two
columns and b table have 3 columns in two tables are
metadata to be same that time we can use column generator
stage for getting total columns in a target

Is This Answer Correct ?    7 Yes 0 No

where we use column generator stage in real time scenario?..

Answer / indian

If you want to generate the mockdata for new column for
testing purpose we will use this stage.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Data Stage Interview Questions

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  


1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,


Name the different sorting methods in datastage.

0 Answers  


describe the Steps to confiure a Qlogic switch

0 Answers   IBM,


What is a merge?

0 Answers  






I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,


how to sort two columns in single job in datastage.

0 Answers   TCS,


1)How to Duplicate Records Delete in Sequential file?

4 Answers   IBM, TCS,


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,


How do you register plug-ins?

0 Answers  


HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  


WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,


Categories