Answer / manash roy chawdhury

TAKING CALLS
SESSION TASK
MAIL TASK & CLOSING TASK

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

Write the prerequisite tasks to achieve the session partition?

0 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,

---

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

What is complex mapping?

0 Answers  

---

How the dimensions will be loaded?

0 Answers   HCL,

---

explain about session partitions ?

1 Answers  

---

What are the types of data warehouses?

0 Answers   Informatica,

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

---

How many input parameters can exist in an unconnected lookup?

0 Answers  

---