Interested to Buy Any Domain ? << Click Here >> for more details...
how to identifie,is it innerjoin,leftouter join in lookup?
- 2 Answers
- 36291 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
sed,awk,head
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
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Define Merge?
In Datastage, how you can fix the truncated data error?
Explain how a source file is populated?
Describe stream connector?
What is the purpose of interprocessor stage in server jobs?
What are datastage sequences?
What are the different kinds of views available in a datastage director?
Explain connectivity between datastage with datasources?
What is apt_config in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
Is the value of staging variable stored temporarily or permanently?
