Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between mapping parameter and mapping variable?
- 1 Answers
- 1561 Views
- I also Faced
- E-Mail Answers
Answer Posted / ysindhureddy77@gmail.com
A mapping parameter is a user definable constant that takes up a value before running a session. It can be used in SQ expressions, Expression transformation etc.
A mapping variable is also defined similar to the parameter except that the value of the variable is subjected to change. It picks up the value in the following order.
From the Session parameter file
As stored in the repository object in the previous run
As defined in the initial values in the designer
Data type Default values
| Is This Answer Correct ? | 0 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?
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
How to create Target definition for flat files?
where to store informatica rejected data?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is deployment group?
What is a transaction control transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
What is primary and backup node?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain the different kinds of facts.
What are the new features of informatica 9.x developer?
Mention a few design and development best practices for informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Why sorter is an active transformation?
