Answer Posted / sanchit aggarwal(oracle dev.)

CREATE TABLE EMPLOYEE(

[EMPLOYEE_ID] INT PRIMARY KEY,

[NAME] NVARCHAR(50),

[MANAGER_ID] INT

)

GO

INSERT INTO EMPLOYEE VALUES(101,'Mary',102)

INSERT INTO EMPLOYEE VALUES(102,'Ravi',NULL)

INSERT INTO EMPLOYEE VALUES(103,'Raj',102)

INSERT INTO EMPLOYEE VALUES(104,'Pete',103)

INSERT INTO EMPLOYEE VALUES(105,'Prasad',103)

INSERT INTO EMPLOYEE VALUES(106,'Ben',103)


select e1.name from employee e1,employee e2
where e1.employee_id = e2.manager_id

Explain what a database is?

1085

---

fact table and dimension table containg one to many relationship or many to one relastionship

2546

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2902

---

Explain about post-relational databases?

1075

---

How long can an error message be in raiseerror function?

1043

---

What is data modeling with example?

1059

---

What is the physical representation for a many-to-many relationship?

1133

---

How would you design a database for an online site, which would average a million hits a day?

1050

---

How to replace not in with not exist?

2172

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1071

---

How can you log an error to the server event log from a stored procedure?

1170

---

How can you fix a poorly performing query?

1253

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2082

---

explain detail about ftp in datastage?

2288

---

Write short notes on manual refreshes.

2782

---