Answer / Amrit Kumar

In SQL, the LEFT JOIN keyword returns all records from the left table (movie), and the matched records from the right table (director). If there is no match, the result is NULL on the right side. Here's an example:n```nSELECT movie.title, director.namenFROM movienLEFT JOIN director ON movie.director_id = director.id;n```

What is a data warehousing?

1 Answers  

---

What is an error log table in informatica occurs and how to maintain it in mapping?

1 Answers  

---

What is conformed dimension?

6 Answers   Polaris,

---

What is the difference between drill through and masterdetail reports?

1 Answers  

---

How can you set the session management?

1 Answers  

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

1 Answers  

---

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

1 Answers   L&T,

---

How to add a number to a macro variable?

1 Answers  

---

How can we run the graph?

1 Answers  

---

What is dimensional modelling?

1 Answers  

---

How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.

1 Answers   IBM,

---

Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---

1 Answers   Principal Finance, PT Metalogix Infolink Persada,

---