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 |
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
Differentiate between odbc and drs stage?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
HOW CAN WE SEE THE DATA IN DATASET?
what is flow of project?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)