Interested to Buy Any Domain ? << Click Here >> for more details...
What are the prerequisites for join stage
- 2 Answers
- 9625 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
can we use sequential file as a lookup
where we use column generator stage in real time scenario?
What could be a data source system?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
Give an idea of system variables.
Highlight the main features of datastage?
How rejected rows are managed in datastage?
What are the various kinds of containers available in datastage?
how to add a new records into source?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
Describe the architecture of datastage?
Teradata 
