where we use column generator stage in real time scenario?
Answer Posted / 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 |
Post New Answer View All Answers
What is difference between symmetric multiprocessing and massive parallel processing?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is use Array size in datastage
What are the types of containers and how to create them?
What is a folder? Difference types of stages?
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
Can you implement SCD2 using join, transformer and funnel stage?
What is apt_config in datastage?
What are the partitioning techniques available in link partitioner?
What are the various kinds of the hash file?
What is job control?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
If you want to use the same piece of code in different jobs, how will you achieve it?
Can you explain kafka connector?
What are the main features of datastage?