Answer / vinod saini

Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile

Answer / veera

When/Under what circumstances do we use dynamic and static
cache in connected
lookup?
When/Under what circumstances do we use static cache in
unconnected lookup?

Answer / bc

we can use dynamic and static cache in connected
lookup..and we can use only static cache in unconnected
lookup.

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

WAT IS TEXT LOAD?

3 Answers   Wipro,

---

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

COM components can be used in Informatica

0 Answers  

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

What is polling?

1 Answers  

---

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,

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---