Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the difference between datastage and informatica?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Could anyone give brief explanation bout datastage admin
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Name the third party tools that can be used in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How do you run datastage job from the command line?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Can you explain kafka connector?
Explain datastage architecture?
How do you import and export data into datastage?
Highlight the main features of datastage?
What is use Array size in datastage
What is meta stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
