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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the different type of jobs in datastage?

585


How a source file is populated?

628


What is the project in datastage?

679


What is quality stage?

579


How to implement complex jobs in data stage?

625






What is a merge in datastage?

784


What are the differences between datastage and informatica?

585


Why do we use exception activity in Datastage?

737


What are routines in datastage?

795


What are the different type of jobs in datastage?

618


What are sequencers?

626


What are the different layers in the information server architecture?

647


What is the difference between an operational datastage and a data warehouse?

647


Why fact table is in normal form?

694


Can you explain tagbatch restructure operator?

712