When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 Answers  

---

How to delete data which is not in source table?

0 Answers   IBM, Saama Tech, Wipro,

---

How many steps etl contains explain with example?

0 Answers  

---

Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10

0 Answers   Cap Gemini,

---

Explain different types of partitioning?

0 Answers  

---

what is the difference between cardinality and Nullability?

0 Answers  

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  

---

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,

---

What is cube grouping?

0 Answers  

---

what is the difference steps for data modeling?

0 Answers  

---

How to increase performance without changing anything in mapping.( In prod)

0 Answers   IBM, Saama Tech, Wipro,

---

what is the advantage of persistent cache? when it should be used?

2 Answers  

---