Answer Posted / shar
1.Inputs as left right and intermediate links(files).
2.can do left outer,right outer,inner join and full outer join
3.N inputs for left,right and inner but 2 inputs for full outer.
4.Inputs should be sorted and partitioned for better
performance.
5.Removing duplicates is optional as join operation is
highly optimized which sequential and less i/o and less page
faults.
6.Memory requirements are comparatively less than Lookup stage.
7.In join key columns names should be same in primary and
secondary datasets.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Have you used Unstructured data?
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)
table actions available in oracle connector?
Explain how a source file is populated?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the different type of jobs in datastage?
Explain datastage architecture?
What is a datastage job?
What is the purpose of pivot stage and types of containers in datastage
How do u convert the columns to rows in datastage?
What is meta stage?
How to read the length of word in unix?
What is the method of removing duplicates, without the remove duplicate stage?
What is data partitioning?
How to find value from a column in a dataset?