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

What is RCP

5 Answers   CGI, CTS,


Which commands are used to import and export the datastage jobs?

0 Answers  


I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,


My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,


What is the sortmerge collector?

0 Answers  






I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,


What is the importance of the exception activity in datastage?

0 Answers  


hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,


Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers   Wipro,


how to delete one row in target dataset

0 Answers   Satyam,


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?

2 Answers  


Categories