In datastage can ve find the job based on source table name ??

1 Answers   TCS,

---

if source contain 10records how you identify header and footer

2 Answers   Polaris,

---

Explain what are conformed dimensions?

0 Answers  

---

How to pivot row data using informatica?

0 Answers  

---

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

0 Answers  

---

Explain what are the different types of join operations?

0 Answers  

---

What is a real-time data warehouse?

0 Answers  

---

What are components of reportnet?

0 Answers  

---

Explain ddl (data definition language)?

0 Answers  

---

What are the different types of data warehouses?

0 Answers  

---

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,

---

which automation tool is used in data warehouse testing?

1 Answers  

---