Answer / swetha

Static cache
Dynamic cache

U can not inert or update the cache. yoU
can insert rows into the cache as u pass


to the target

The informatic server returns a value from The
informatic server inserts rows into cache

the lookup table opr cache when the condition when the
condition is false.This indicates that

is true. When the condition is not true, the
the row is not in the cache or target table.

informatica server returns the default value yoU
can pass these rows to the target table.

for connected transformations and null for

unconnected transformations.

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

---

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

What is update override?

1 Answers   Accenture,

---

what is sql override?what is the use of it?

4 Answers   Sonata,

---

What is mapplet in informatica?

0 Answers  

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---