Answer / arun

A dimension which have frequent changes. These type of dimensions can be maintained by splitting up the frequently changing attributes in to sub dimensions (More like a Normalized structure), so history can be maintained with less storage. But retrieval may be time consuming.

Can i create a lookup table without cache.

7 Answers   iGate,

---

What is hash partition?

1 Answers  

---

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

How we can use union transformation?

0 Answers  

---

what is workflow varible

1 Answers   HP,

---

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---