Answer / swetha

Under certain circumstances, when a session does not
complete, you need to truncate the target tables and run the
session from the beginning. Run the session from the
beginning when the Informatica Server cannot run recovery or
when running recovery might result in inconsistent data.

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

---

How we can create indexes after completing the load process?

0 Answers  

---

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

---

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,

---