how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

---

How to load a Dimension ? and how to load a fact table?

0 Answers  

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

where to select code page option?

2 Answers   TCS,

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

Which kind of index is preferred in DWH?

2 Answers  

---