how to identifie,is it innerjoin,leftouter join in lookup?
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 ? | 41 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 |
options available in sequence job to run,validate?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
How to implement complex jobs in data stage?
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
what is a nodemap constraint
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
What are stage variables, derivations and constants?
how to do pergformence tuning in datastage?