Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

---

What is the difference between IN and Exists in Oracle?

3 Answers   Deloitte,

---

Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

Write the different tools in the workflow manager?

0 Answers  

---

---

Explain in detail about scd type 1 through mapping.

0 Answers  

---

What is a filter transformation and why it is an active one?

0 Answers  

---

what is data driven in informatica

5 Answers   IBM,

---

In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

how to move the mappings from your local machine to claint place?

2 Answers  

---