How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  

---

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

---

can we use cartesian join in informatica

3 Answers   IBM,

---

Difference between Target-based loading and constraint-based loading?

0 Answers  

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

---

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

What are the different threads in DTM process?

2 Answers  

---

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---