Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swetha
Parameter file is to define the values for parameters and
variables used in a session.A parameter file is a file
created by text editor such as word pad or notepad.
yoU can define the following values in parameter file
Maping variables
session parameters.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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?
What are the different options available for update strategy?
What is a rank transform?
What do you mean by filter transformation?
can you please explain me pre session and post session options?
What are the modules in Power Center
How does the aggregator transformation handle null values?
What is incremental aggregation?
Define mapplet?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is informatica worklet?
What are active transformations.
What is Index Caches size?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
