Answer / Arti Kumari

Table scan refers to reading every record from a table sequentially to retrieve data. This method is used when there is no index available for the query or the index is not efficient for the given query. Index scan, on the other hand, uses an index to quickly locate the required records in a table without having to read the entire table.

How to do Data size testing? Who does this testing (Developer or tester)?

1 Answers  

---

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)?

1 Answers  

---

What do you mean by cluster and non cluster index?

1 Answers  

---

Explain file manager?

1 Answers  

---

What is odm in database?

1 Answers  

---

What is ole db provider for sql server?

1 Answers  

---

What are the advantages of views in a database?

1 Answers  

---

Is storing images in a database a good idea?

1 Answers  

---

What is difference between data and database?

1 Answers  

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1 Answers   Miracle Software,

---

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

1 Answers   CybAge,

---

please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

1 Answers  

---