what is usage of datastage with materialized views
Answer Posted / kpk
Materilized views are similar to normal views, but the
difference is, materilized views are stored in the databse
and they are refereshed timely to get the new data....
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is the command line function to import and export the ds jobs?
what are the devoleper roles in real time? plz tell i am new to datastage....
How the ipc stage work?
Can you explain engine tier in information server?
client know skid info?
how to write server Routine coding?
What is a merge?
Distinguish between informatica & datastage. Which one would you choose and why?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
how to abort the job its matain duplicates?
Describe stream connector?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is size of a transaction and an array means in a datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?