Interested to Buy Any Domain ? << Click Here >> for more details...
what is the best stage in datastage parller jobs to use full
out join and why
- 5 Answers
- 15950 Views
- Virtusa, I also Faced
- E-Mail Answers
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
Define repository tables in datastage?
Differentiate between datastage and informatica?
Does datastage support slowly changing dimensions ?
Differentiate between operational datastage (ods) and data warehouse?
How a routine is called in datastage job?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How rejected rows are managed in datastage?
What are the functionalities of link collector?
How to read multiple files using a single datastage job if files have the same metadata?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the process of killing a job in datastage?
Is it possible to query a hash file?
Where do you see different stages in the designer?
What is a datastage job?
