Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14361 Views
- I also Faced
- E-Mail Answers
Answer Posted / sarvesh
VIEW IS THE VIRTTUAL TABLE,AND WE CANOT REFRESH THE
DATA ,BUT IN MATERIALISED VIEW WE CAN REFRESH THE DATA
FREQUNENTLY,AND BY USING M.VIEW THE PERFORMANCE WILL BE
INCREASED.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to convert multiple rows to single row (multiple columns) in informatica
What is the benefit of session partitioning?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what are 3 tech challenges/ common issues you face?
How do you load first and last records into target table?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are some examples of informatica etl programs?
How would you copy the content of one repository to another repository?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
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 do unit testing in informatica?
