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
- 5929 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 "fatal error/rdbms code 3996" error?
What is merge stage?
Can you explain engine tier in information server?
Name the different types of Lookups in Datastage?
Define Job control?
What are the different type of jobs in datastage?
How many types of stage?
What is oci?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Define repository tables in datastage?
How you can fix the truncated data error in datastage?
What is ibm datastage?
What are the repository tables in datastage?
