what is the main differences between Lookup, Join and Merge
stages?
Answer Posted / kishore
ANother different is Lookup dont do sorting internally ,
where Merge and Join stage do sorting while data processing .
2. If there are dpluciate records at source , Merge stage
will gives warning but Join stage wont give ,
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
what is use of SDR function?
Differentiate between datastage and informatica?
Which commands are used to import and export the datastage jobs?
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 flow of project?
What can we do with datastage director?
describe the Steps to confiure a Qlogic switch
What is the roundrobin collector?
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 ?
What is a ds designer?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
how to abort the job its matain duplicates?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance