Answer / davan

i session properties we have a option

Answer / sunny

SESSIONS>>CONFIG OBJECT TAB>>STOP ON ERRORS =10

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

in which situations do u go for snowflake schema ?

2 Answers   TCS,

---

What is persistent lookup cache?

0 Answers  

---

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

---

Explain about HLD and LLD ?

16 Answers   Accenture,

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,

---

what is materialized view?

2 Answers  

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

---