Answer / guest

we can not have flat override in any of the Transormation.
We have only sql query here we can use the custom query for
relational sources and we have lookup override is there
here we can sql query for relational sources suppose we
going to lookup on relational table.

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

---

Difference between Data and Index Caches?

0 Answers   Informatica,

---

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

how we can update a target table without update strategy and update override?

3 Answers   TCS,

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

Explain grouped cross tab?

1 Answers   Accenture,

---

What are Target Options on the Servers?

1 Answers  

---

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

---