Diff B/W
MAP Parameter,
SESSION Paramater,
DataBase connection session parameters.?
Its possible to Create 3parameters at a time?
If Possible which one will fire FIRST?
Answer Posted / sasmita panda
If we need to change certain attributes of a mapping after
every time the session is run, it will be very difficult to
edit the mapping and then change the attribute. So we use
mapping parameters and variables and define the values in a
parameter file. Then we could edit the parameter file to
change the attribute values. This makes the process simple.
In a mapping parameter we need to manually edit the
attribute value in the parameter file after every session
run
Session parameters are like mapping parameters, that
represent values you might want to change between sessions
such as database connections or source.
Yes it is possible to create 3 parameters at a time.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a passive transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the difference between Active and Passive transformation?
What is data transformation manager process?
Design time, run time. If you don't create parameter what will happen
Describe expression transformation?
What is the fact table?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a filter transformation?
How do you use reject loader.
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
Different circumstance which drives informatica server to expel records?
How you prepared reports for OLAP?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the uses of etl tools?