Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main differences between Lookup, Join and Merge
stages?
- 9 Answers
- 149044 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / pavan
We go for a join stage than a lookup when the referntial
data in look up is more ie.,>=500MB.we have outer joins in
join stage but not in merge stage.we have only inner join
in merge stage.
| Is This Answer Correct ? | 12 Yes | 26 No |
Post New Answer View All Answers
Differentiate between hash file and sequential file?
What is quality stage?
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...
How do you generate sequence number in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are the partitioning techniques available in link partitioner?
Differentiate between odbc and drs stage?
What is process model?
What are stage variables?
What is use Array size in datastage
Lookup constraints
Differentiate between Join, Merge and Lookup stage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
