How to write a left outer join condition by using
Transformer stage in server jobs?
Could any one help me?
Answer Posted / rakesh
default is left outer join Dude you just make sure in transformer you joiin them based n the key, that's it
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
EXPLAIN SCD
Differentiate between operational datastage (ods) and data warehouse?
Define Job control?
What is apt_config in datastage?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are stage variables and constants?
Why fact table is in normal form?
What are the different kinds of views available in a datastage director?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Define oconv () and iconv () functions in datastage?
What are the different type of jobs in datastage?
Differentiate between odbc and drs stage?
what is ds administrator used for?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How to read multiple files using a single datastage job if files have the same metadata?