-
Loading data to multiple targets
how to create mapping that half records will go to one target and half to another target?
-
Joiner Transformation Limitations
What are limitations and delimitations of Joiner Transformation?
-
Cache Files
What are the T/Rs which create cache files?
-
Delete Child Record transformations
If i delete one record in master table, then the same record is also deleted in dependent table, for this which transformation can we use.
-
-
How you will avoid your query from using indexes?
SELECT * FROM empWhere emp_no+' '=12345;i.e you have to concatenate the column name with space within codes in the where condition.SELECT /*+ FULL(a) */ ename, emp_no from empwhere emp_no=1234;i.e using HINTS