Answer / vanita

For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

---

what is the monster dimension plz give me one example

2 Answers   EDS,

---

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

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,

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

---

in static and dynamic which one is better

2 Answers  

---

Difference between task flow and linear task flow

0 Answers  

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

What is query panel?

1 Answers  

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,

---