1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

how to use self join using datastage ?
can u tell me using stage how can we implemnet the self join

Question Posted / kiran


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join..

Answer / Akhelesh Kumar

In DataStage, you can perform a self-join by creating two stages: one for the source and another for the join operation. Here's an example using a simple table (EMPLOYEES) with columns EMP_ID, NAME, AGE, DEPARTMENT:nn1) Create a stage named 'Source' to read data from the EMPLOYEES table.n2) Create a stage named 'Self Join' that performs the join operation. In this stage, you would use the JOIN Transformation and connect two Data Flows: one for the source data and another for the previous iteration of the data flow (created by using a LOOP Transformation).n3) Configure the join condition in the JOIN Transformation.n4) Connect the 'Self Join' stage to an output stage or another transformation based on your requirements.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

1)Source file contains one record, I want 100 records in target file.

3 Answers  

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1 Answers  

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1 Answers  

What are system variables and sequencers in datastage

1 Answers  

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

How to manage date conversion in Datastage?

1 Answers  

How to perform incremental load in datastage?

1 Answers  

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

describe the Steps to confiure a Qlogic switch

1 Answers   IBM,

What are the partitioning techniques available in link partitioner?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories