Answer / sam

Performance wise unconnected lookup transformation is better as it returns one port & does not build dynamic cache. only static cache is build .

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

---

What is Code Page Compatibility?

1 Answers  

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

How to enter same record twice in the target table,explain?

7 Answers  

---

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---

What are the types of data warehouses?

0 Answers   Informatica,

---

What is meant by query override?

0 Answers  

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---