what is the best stage in datastage parller jobs to use full
out join and why
Answer Posted / swetha
use the join stage rather than using lookup and merge stages. join stage supports all the joins like inner join,leftouter join,right outer join,full outer join
lookup supports only inner,leftouter only
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
I have a few records just I want to store data in to targets cycling way how?
Differentiate between datastage and informatica?
how to add a new records into source?
describe the Steps to confiure a Qlogic switch
How can we improve the performance in datastage?
How to Remove Duplicate using SQL?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How many types of views are there in a datastage director?
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
What are the components of ascential data stage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Can you explain tagbatch restructure operator?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How do y read Sequential file from job control?