Interested to Buy Any Domain ? << Click Here >> for more details...
How to compare Source and Target table, without using
dynamic lookup?
- 4 Answers
- 11001 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagaraju bhatraju
YOu can join the Source and target columns at the source
qualifer level,if you have public synonym on the target, so
that the table can be accessed from all the schemas.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
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 are the different types of olap? Give an example?
How can you define user defied event?
How many ways are there to create ports?
how to create user defined function (udf) in informatica
Explain transaction control transformation in informatica
Explain sessions?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to create or import flat file definition in to the warehouse designer?
What is the function of aggregator transformation?
How do we call shell scripts from informatica?
How can repository reports be accessed without sql or other transformations?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the use of target designer?
Why update strategy and union transformations are active? Explain with examples.
