where we use column generator stage in real time scenario?
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 |
what is the difference between the join and look up explin me one exmple
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
What are the different types of lookups in datastage?
Wat is pre-load in Hashed file
what is datastage job Monitoring
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
Wat is isolation level and when do u use them?
How to generate surrogate key without using surrogate key stage?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?