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.

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

---

Explain about perform recovery?

1 Answers  

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

What is event and what are the tasks related to it?

0 Answers  

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

what is parameter file?

1 Answers   Cap Gemini,

---