Interested to Buy Any Domain ? << Click Here >> for more details...
there is a mapping with expression and mapping we create
some condition for insert and update and followed by update
startegy ,can we update and insert on a single target based
on condition?
- 1 Answers
- 4733 Views
- Emphasis, I also Faced
- E-Mail Answers
Answer Posted / gm
Yes, We can do both in Update Startegy,
SOURCE-SQ-EX-LKP-UPD-TAGET
In Update Startegy IIF(ISNULL(EMPID),DD_INSERT,DD_UPDATE)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the various types of transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Why update strategy and union transformations are active?
What are the new features of Power Center 5.0?
What is a pre-defined event and user-defined event?
What is source qualifier transformation in informatica?
what is the Default Source Option For Update Strategy Transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Have you worked with/created Parameter file
How to implement security measures using repository manager?
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 incremental aggregation?
What are active transformations.
How can a transformation be made reusable?
What is different between the data warehouse and data mart?
