above answer has one mistake i.e join doesn't has sort operation byde

if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?

Question Posted / ashok

Answer Posted / ashok

above answer has one mistake
i.e join doesn't has sort operation bydefault we explicitly
specify

Is This Answer Correct ?

9 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Define Merge?

1261

what is flow of project?

1938

What are the processing stages?

1041

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

2391

Differentiate between datastage and informatica?

1141

Can you explain link buffering?

1111

What are the different options associated with dsjob command?

1372

How to RD using transformer?

1367

What are the functionalities of link collector?

1038

Describe the architecture of datastage?

953

What are the difference types of stages?

1134

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2003

What are the repository tables in datastage?

1259

Can you implement SCD2 using join, transformer and funnel stage?

1501

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

954