1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

0 Answers   Wipro,

---

What are the ACID Properties in a Database and Why are They Important?

1 Answers  

---

Mention a query to add email validation to your database

0 Answers  

---

What is a 3nf table?

0 Answers  

---

Enlist some commands of dml?

0 Answers  

---

Explain about the case statement present in stored procedure?

0 Answers  

---

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time? 1. What are environment variable, job parameters? 2. What is the relationship between the tables in oracle? 3. How can u create the sequence? 4. What are the client components? 5. Tell me about the Data stage administrator? 6. Tell me about the Data stage Manager? 7. What is joining? 8. What is difference between grep command and fgrep command? 9. What is run time column propagation? 10. How to open the file? 11. How do you cleanse the data in your project? 1. Using which stage raw binary converted into dataset? 2. Which stage is used to read the data into external application? 3. Can we convert dataset into raw binary 4. XML path? 5. When we use the hash partition in aggregator stage? 6. How many reject links in transformer stage? 7. Data stage debugger available in which jobs? 8. Tell me two parts of data set? 9. What is the function used for null handling in modify stage? 10. Default execution mode for exception handler? 11. Maximum exception handler allowed in sequence?

0 Answers   Wells Fargo,

---

HI THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS POSSIBLE BY USING DATASTAGE7.5.

1 Answers  

---

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

0 Answers  

---

What are stored procedures in a database?

0 Answers  

---

How to tell firebird to only accept conections from xyz host or network?

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,

---