Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a table and the materialized
view?
- 2 Answers
- 8317 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
Under what condition selecting sorted input in aggregator may fail the session?
What is DR strategy for Informatica project?
What is a mapplet/worklet in informatica?
what are 3 tech challenges/ common issues you face?
What do you understand by SOA of Informatica?
What is main use of mapplet?
What are the data movement modes in informatica?
Explain about cumulative Sum or moving sum?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier 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
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Define sessions in informatica etl?
Which files are created during the session rums by informatics server?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How union transformation is used?
