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



Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its po..

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

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its po..

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

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its po..

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

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its po..

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

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its po..

Answer / srinu

Lokendra,The order was ok,
Diff b/w them,which one is best

Is This Answer Correct ?    0 Yes 0 No

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its po..

Answer / ebenezer

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

Post New Answer

More Informatica Interview Questions

Tell me about informatica architecture.

2 Answers   TCS,


which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

4 Answers   IBM, Infotech,


Which files are created during the session rums by informatics server?

0 Answers  


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,


Explain lookup transformation in informatica

0 Answers   Informatica,


in performance wise union is past,union all is past

2 Answers  


what are the difference between Informatica 7.1 and 8.1?

6 Answers  


What are the types of schemas we have in data warehouse.

0 Answers  


what is casual dimension?

6 Answers   IBM,


How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


Categories