Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a table and the materialized
view?
- 2 Answers
- 8279 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepthi
1.Refreshing of data is possible in materialised views. we
can restrict rows of data for acces from other users in
materialised views.
above mentioned two points are not possible with table.
Thanks
Deepthi
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is target load order?
What are the advantages of using informatica as an etl tool over teradata?
Explain the different lookup methods used in informatica?
Enterprise data warehouse your projects phase by phase explain?
Can we get 1st record through Informatica(without sequence number).
have u done any performance tuning? how u ll do?
What are active transformations.
Explain the etl program with few examples.
What is a transaction control transformation?
What is the status code in stored procedure transformation?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How to load data in informatica ?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what is size of u r database?
