Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED
FOR INSERT , UPDATE OPRATION ?
- 4 Answers
- 13729 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
when we enable dynamic cache in lookup one lookup port will be
created called NEW LOOKUP PORT.it is generate numeric values
in cache.
this will just synchronize data in lookup and target for
inserting and updating records.
chandumba2005@gmai.com
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / bsgsr
u mean inserting and updating the source records into the
cache. then the answer shud be insert else update which
lies below dynamic lookup port.
| Is This Answer Correct ? | 1 Yes | 4 No |
in realtime which situations u can use unconnected lookup transformation
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
In ur current projectu have done any performance tuning of mappings?
What are the types of error logs available in Informatica?
what are the difference between Informatica 7.1 and 8.1?
What are the types of maping wizards that r to be provided in Informatica?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
How can i set break points in debugging mode ? can explain steps please?
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
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is data movement mode in Informatica and difference between them?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
Teradata 
