Interested to Buy Any Domain ? << Click Here >> for more details...
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 informatica performance improvement tips
What are the different transaction levels available in transaction control transformation?
What will be the approach?
Differentiate between reusable transformation and mapplet.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is a rank transform?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are data-driven sessions?
What is pmcmd command?
how to create user defined function (udf) in informatica
What is the different lookup cache(s)?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
