Answer Posted / mike
Well in simple terms
A meterialized view is a view that contains data in some
temporary tables. If we consider the view at database level
it only stores the query , when ever we call the view it
extracts the data from the database based on the query...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the databases that informatica can connect to windows?
What is a connected transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
On which transformations you created partitions in your project?
What are mapplets?
What is the function of look up transformation?
What are the restrictions of union transformation?
What is InformaticaPowerCenter?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain informatica architecture - version 8 / 9
In development project what is the process to follow for an etl developer from day1
How do you convert single row from source into three rows into target?
How to handle decimal places while importing a flatfile into informatica?
Clarify the utilization of aggregator cache record?
What do you mean by channel change?