Interested to Buy Any Domain ? << Click Here >> for more details...
how to identifie,is it innerjoin,leftouter join in lookup?
- 2 Answers
- 36197 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 |
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
What is the difference between informatica and datastage?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
What is the roundrobin collector?
what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
what is the main difference between sorragate key n primary key in one word
how to closeing records after 10,000 records come?
Define project in datastage?
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the method of removing duplicates, without the remove duplicate stage?
Teradata 
