Answer / Syed Faseehul Hasan

During my last project, I applied tuning techniques such as optimizing indexes, adjusting caching settings, and fine-tuning SQL queries to improve performance.nFor example, I created optimized indexes on frequently queried columns, adjusted caching parameters to reduce the number of database calls, and rewrote some complex SQL queries to utilize join optimization techniques.

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

---

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

---

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

---

Define maping and sessions?

3 Answers  

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

---

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

---

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1 Answers   CTS,

---