What are the advantages of dbms?

0 Answers  

---

What is db flush?

0 Answers  

---

What are the key constraints in dbms?

0 Answers  

---

How do you copy a database?

0 Answers  

---

Describe the difference between embedded and dynamic sql.

0 Answers  

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60

1 Answers   TCS,

---

Explain what are service-specific middleware?

0 Answers  

---

What do you understand by sub-queries in sql?

0 Answers  

---

What is index hunting and how does it help in improving query performance?

0 Answers  

---

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

0 Answers   IBM,

---

Can you drop all the columns of a table ?

0 Answers   MCN Solutions,

---

Explain bcnf (boyce-codd normal form)?

0 Answers  

---