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

0 Answers  

---

What is update strategy transform?

0 Answers  

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

---

what are the limitation of sorter transformation?

2 Answers   TCS,

---

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

What did you do in source pre load stored procedure

1 Answers  

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---