Interested to Buy Any Domain ? << Click Here >> for more details...
where we use column generator stage in real time scenario?
- 5 Answers
- 26956 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 |
Is it possible to query a hash file?
How many Key we can define in remove duplicate stage?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
How rejected rows are managed in datastage?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
How to use Environment variable's in datastage?(use of process)
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
What is the difference between Datastage 7.5 and 7.0?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the default execution order of the sequential file?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
How to enter a log in auditing table whenever a job get finished?
Teradata 
