how to identifie,is it innerjoin,leftouter join in lookup?
- 2 Answers
- 34653 Views
- Hexaware, I also Faced
- E-Mail Answers
Answer Posted / saidarao
GO TO CONSTRAINTS IN LOOKUP PROPERTIES
HERE OPTIONS LIKE-DROP,CONTINUE,FAIL,REJECT .
DROP MEANS MATCHING RECORDS
CONTINUE MEANS LEFT OUTER
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between server job and parallel jobs?
What is the sortmerge collector?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is a ds designer?
What is the difference between odbc and drs stage?
how many rows sorted in sort stage by default in server jobs
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Explain entity, attribute and relationship in datastage?
What are the types of containers?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is job control?
Can you explain link buffering?
What is datastage engine?
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
