Answer / sanjay gupta

Normally we use two types of indexes in informatica.
Btree Index
Bitmap Index

Bitmap Index gives better performance than Btree Index.

Answer / javidakram

b tree and bitmap indexes we r using in informatica. b tree
is low cardinality and bitmap have high cardinality that is
why bitmap index gives better performance.

How can you define user defied event?

0 Answers  

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

---

What is resilience time?

0 Answers  

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---