Answer / urs

When we are using the lookup cache as dynamic at first run
it will stores the all lookup table records into the cache
but second run it will check whether the incoming source
record having in the target table or not..if the record
exist in target table it will update otherwise it will
insert..this load type is done based on your condition
...nothing will happen in cache..

Answer / santosh kumar sarangi

Hi Urs, as you told, if record exit then it will update so
can you please clarify which one it will update cache or
target table. If it will update the target table the why we
need the update strategy T/R.

In my view, if any things updating in the dynamic look up
cache then it's responsibility of developer to update the
same in the target, other wise look up cache and target will
not be in sync,

Answer / chandrasekar

IF THE LOOKUP CONDITION IS TRUE THEN THE RECORD IS LOADED IN
CACHE AS WELL AS IN TARGET BUT THE TARGET FAILED MEANS
RECORD ONLY LOADED IN CACHE.

IF IT IS WRONG MEANS PLEASE MAIL ME chandranmca2007@gamil.com

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

---

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

What is the need of etl tools?

0 Answers  

---

What are some examples of informatica etl programs?

0 Answers  

---

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

---

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

1 Answers   IBM,

---

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

---

how to join two flat files in informatica?

3 Answers   Wipro,

---

What is the session task and command task?

0 Answers  

---

Explain the aggregator transformation?

0 Answers  

---

what is the flat file partition and where have to specify it

1 Answers   TCS,

---