what is the use of materialized view?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Stage Interview Questions

In one project how many shared containers are created?

3 Answers   NTT Data,


1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,


Describe stream connector?

0 Answers  


in oracle target stage when we use load option and when we use upsert option?

0 Answers  


in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?

2 Answers   Wipro,






Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is  Empno 1                                2 3 4 5 6 7 8 9 10                                                                                             

5 Answers   Tech Mahindra,


What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  


i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  


if ename='subbu' while running job the job should be abort how come?

3 Answers   IBM,


how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,


what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  


How to read the length of word in unix?

0 Answers   CTS,


Categories