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 |
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
On which interface you will be working as a developer?
How will you move hashed file from one location to another location?
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
Describe stream connector?
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
Can you explain how could anyone drop the index before loading the data in target in datastage?