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.

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

What are the types of error logs available in Informatica?

1 Answers  

---

How to partition the Session?

0 Answers   Informatica,

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

---

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

---

What is an Integration service in Informatica?

0 Answers  

---

What is enterprise data warehousing?

0 Answers  

---

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---