Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

0 Answers  

---

What the various ways to tune a teradata query

0 Answers  

---

What is difference between clustered, non-clustered and unique index?

0 Answers   Abacus,

---

Explain phantom deadlock?

0 Answers  

---

How do you pass parameter in stored procedure?

0 Answers   CGI,

---

give a simple example of physical and logical data independence

0 Answers  

---

What do you mean by foreign key and primary key?

0 Answers   Zensar,

---

How many indexes can be created on a table?

0 Answers   Abacus,

---

write a query for the fifth highest salary?

17 Answers   IBM, Matlabs, Ramco,

---

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

0 Answers  

---

Which database is best to store images?

0 Answers  

---

what are wrappers and build ups and what it's use?

0 Answers   TCS,

---