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 are the some differences between 7.x and 8.x version of datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
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?
Demonstrate experience in maintaining quality process standards?
How to perform incremental load in datastage?
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
Can we use target hash file as a lookup ?
Differentiate between hash file and sequential file?
What are the different plug-ins stages used in your projects?
explain about citrix scheduling tool in datastage
If you want to use the same piece of code in different jobs, how will you achieve it?
How to read the length of word in unix?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to read multiple files using a single datastage job if files have the same metadata?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys