Interested to Buy Any Domain ? << Click Here >> for more details...
how to identifie,is it innerjoin,leftouter join in lookup?
- 2 Answers
- 36076 Views
- Hexaware, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kak
double click on lookup --->lookup failure --->if it is drop
then it is inner join. If it is continue then it is left
outer join.
| Is This Answer Correct ? | 42 Yes | 1 No |
Answer / 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 |
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
Nls stands for what in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
How do you find the number of rows in a sequential file?
What is a folder? Difference types of stages?
How a server job can be converted to a parallel job?
How do you register plug-ins?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
how to sort two columns in single job in datastage.
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
what is factless fact table?
Teradata 
