where we use column generator stage in real time scenario?
- 5 Answers
- 27206 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
how can or from where we can get reference data in scd type2 implementation?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
Can you explain how could anyone drop the index before loading the data in target in datastage?
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
How can you join flat file, oracle as a sources?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
What are the repository tables in datastage?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
What is a merge?
How do you load 10 different sources with 10 different layouts to 10 different tables?
What are some different alternative commands associated with "dsjob"?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Teradata 
