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 can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

how to use incremental load?

2 Answers   TCS,

---

Two different admin users created for repository are ______ and_______

1 Answers  

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  

---

what is the gap analysis?

1 Answers  

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---