what is the difference between the join and look up
explin me one exmple
Answer Posted / shar
join lookup
i/p names- left,right,intermediate primary,secondary
join ops - left,right,inner,fullout left,inner
in & out - n i/p(s)-left,right,inner n i/p(s) normal
2 i/p(s)-full outer 2 i/p(s) sparse
1 o/p 1 o/p
rejects - n/a one
sort data- Mandatory optional
KcolNames- Mandatory optional
deduplica- no problem warnings in secondary.
memory - light high
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How we can covert server job to a parallel job?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the some differences between 7.x and 8.x version of datastage?
Differentiate between hash file and sequential file?
What are the different kinds of views available in a datastage director?
Explain entity, attribute and relationship in datastage?
Can you explain engine tier in information server?
Can you define merge?
What is a folder? Difference types of stages?
What is the difference between server job and parallel jobs?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the various kinds of the hash file?
What are the types of containers?
What is the purpose of pivot stage?
What are constraints and derivations?