Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56115 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
In view we cannot do DML commands where as it is possible
in Materialized view.
| Is This Answer Correct ? | 39 Yes | 121 No |
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
How can you define a transformation? What are different types of transformations in Informatica?
What are batches?
Differentiate between reusable transformation and mapplet.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What are data-driven sessions?
what is work of PUSH DOWN option
How does the aggregator transformation handle null values?
How do we implement materialized view?when to use materialized view?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
Describe data concatenation?
Teradata 
