WHat all joins are there in Source Qualifier?
Answer / pr
The default join is inner join. But we can override it by using the SQL overide query and can perform any joins
| Is This Answer Correct ? | 0 Yes | 0 No |
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
What are multi-group transformations?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
what is system requirement(SR) & business requirement(BR)?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
what is SDLC way of code development?
What is the difference between router and filter?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Router T/R is active but some people are saying it is also passive which is exactly right?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?