Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / akhil4
this option available in session(work flow) properties.
it increase informatica server performance.
when ever u enable this option it created view in database related to logic.(MEANS YOU TAKEN SEVERAL T/R IN THIS U HAVE IMPLEMENTED LOGIC USING THAT LOGIC IT WILL CREATE A VIEW)
U START WF IT TAKE THE DATA DIRECTLY TO SQ AND PUSH DATA THROUGH LOGIC AND LODES INTO TARGET.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are the new features of informatica 9.x developer?
How can we use mapping variables in informatica? Where do we use them?
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
Performance tuning( what you did in performance tuning)
what is degenerated dimension?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to update or delete the rows in a target, which do not have key fields?
Why do you use Mapping Parameter and mapping variable?
How can a transformation be made reusable?
What is a pre-defined event and user-defined event?
How to configure mapping in informatica?
Explain what transformation and how many are there in informatica?
Design time, run time. If you don't create parameter what will happen
What is meant by target load plan?
Please let me know how to make encryption and decryption with example?
