where we use column generator stage in real time scenario?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the architecture of datastage?

574


Notification Activity

903


Give an idea of system variables.

593


Difference between sequential file and data set?

648


How to read the length of word in unix?

888






What are the different types of lookups in datastage?

634


Difference between server jobs & parallel jobs?

657


which r the connectors used in san?

1798


What is ds designer?

659


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)

530


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

369


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1476


What are the types of jobs we have in datastage?

678


Explain usage analysis in datastage?

657


What are the steps needed to create a simple basic datastage job?

667