Answer / chitti

U CAN TUNE U R QUERIES BY CREATING INDEXES ON COLUMNS,AND
ELIMINATING KEY CONSTRAINTS .AND ALSO GIVE SORTING IN SQL
ITSELF.

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

What is a joiner transformation and why it is an active one?

0 Answers  

---

how do u move the code from development to production?

6 Answers  

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

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

0 Answers  

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

---

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

---

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

---

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

---

Please let me know how to make Data masking in informatica..

0 Answers  

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---