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
How many types of sorting methods are available in datastage?
How a source file is populated?
What is process model?
How to implement complex jobs in data stage?
Name the different sorting methods in datastage.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Define project in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
To see hidden files in LINIX?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
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
What are constraints and derivations?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Can you explain link buffering?
What are the job parameters?