Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mahesh
Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which files are created during the session rums by informatics server?
What is the status code in stored procedure transformation?
Explain sessions. Explain how batches are used to combine executions?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is exclusive and normal mode for repository services?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the main issues while working with flat files as source and as targets ?
Explain the features of connected and unconnected lookup.
What are the types of presistent cache in look up tr.
What is a snowflake schema?
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
write a query to retrieve the latest records from the table sorted by version(scd)
How can we remove the duplicates from flat file source?
Define update strategy?
How to go to the older version for a mapping?
