what is the difference between the join and look up
explin me one exmple
- 3 Answers
- 4769 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
What is a ds designer?
Lookup constraints
Give an idea of system variables.
What is the difference between in process and inter process?
What are routines in datastage? Enlist various types of routines.
What is the difference between operational data stage (ods) and data warehouse?
Explain Quality stage?
How many areas for files does datastage have?
Could anyone give brief explanation bout datastage admin
What are the difference types of stages?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is a folder? Difference types of stages?
State the difference between an operational datastage and a data warehouse?
What are the various kinds of containers available in datastage?
What is the sortmerge collector?
