Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between the join and look up
explin me one exmple
- 3 Answers
- 5911 Views
- I also Faced
- E-Mail Answers
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 many rows sorted in sort stage by default in server jobs
What is difference between symmetric multiprocessing and massive parallel processing?
How to Remove Duplicate using SQL?
How do you remove duplicate values in datastage?
How you can fix the truncated data error in datastage?
What are the job parameters?
What are the steps required to kill the job in Datastage?
Define project in datastage?
Which algorithm you used for your hashfile?
What is the difference between in process and inter process?
How do you start developing a datastage project?
Have you used Unstructured data?
How one source columns or rows to be loaded in to two different tables?
How can one find bugs in job sequence?
Can you explain how could anyone drop the index before loading the data in target in datastage?
