how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.
- 6 Answers
- 16367 Views
- CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
without using update t/mation also we can update. in
session properties select update against treat source rows
as. this wud definitely help you.
push down is a function of 8.1 version of informatica. it
reduces the load on informatica server.
unconnceted obviously bcoz not connected with the data flow
and uses only static cache.
also it can be called as many times in a mapping as a
result of an expession.
reach me on 9866188658.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the features of complex mapping?
What is the need for an etl tool?
How to extract the informatica rejected data?
How to use procedural logic inside infromatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Make a note of the quantity vaults made in informatica?
How does a sorter cache works?
How can you differentiate between powercenter and power map?
Can informatica load heterogeneous targets from heterogeneous sources?
What is a rank transform?
What is depict expression change?
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
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
