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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain in detail about scd type 1 through mapping.

603


Describe expression transformation?

646


What is the difference between router and filter?

656


What is dynamic cache?

624


What is workflow? What are the components of workflow manager?

721






My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5600


What does “tail –f” command do and what is its use as an Informatica admin.

643


What are junk dimensions?

643


How can one identify whether mapping is correct or not without connecting session?

904


Explain the tuning lookup transformation - informatica

625


How to create the source and target database connections in server manager?

644


4 yrs etl devloper roles and responsibilities?any body give solutions

1595


What are the types of presistent cache in look up tr.

1570


Explain how many types of dimensions are available in informatica?

606


What are the modules in Power Center

1248