joining null in MS SQL server, Oracle and informatica
- by jest
hi!
I've two tables to join with a column(say emp_id)..if emp_id in both the tables have null values, how'll MS SQL server and Oracle treat???
Coz, i read that informatica will neglect the NULL rows when joining..if i handle the null, by substituting -1, a cross-join will happen which i don't want..
what can i do here?
I cannot completely…