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?
Answers were Sorted based on User's Feedback
Answer / ajalali
A mapping parameter is set at the mapping level for values
that do not change from session to session for example tax
rates.
Session parameter is set at the session level for values
that can change from sesion to session, such as database
connections for DEV, QA and PRD environments.
The database connection session parameters can be created
for all input fields to connection objects. For example,
username, password, etc.
It is possible to have multiple parameters at a time.
The order of execution is wf/s/m.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / lokendra
we can pass all these three types of perameters by using
Perameterfile.we can declare all in one perameter file.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / lokendra
it will fire in below order workflow,session and data
base perameters from perameter file.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
upto my knowledge, performance wise mapping parameter is
best to use, but according to requirement you can override
the mapping parameters by workflow variable(to know more
about this you can just check the workflow properties) and
session parameters are just database connections....
correct me if i am wrong.
Is This Answer Correct ? | 0 Yes | 1 No |
How you prepared reports for OLAP?
How union transformation is active ?
Design a mapping to get year of join for each employee.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
what is the necessity to use update strategy?(except for updates)
What are the different types of Type2 dimension maping?
what is upstream and downstream transformation?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
what is hash table in informatica?