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?
- 6 Answers
- 16586 Views
- Accenture, HCL, I also Faced
- E-Mail Answers
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 |
What are the tasks that can be performed using sq?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
In which scenario did u used Mapping variable?
Can you generate reports in Informatcia?
Define informatica repository?
Can anyone please distinguish what is Inner join and Outer join
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is mapplet and a reusable transformation?
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
What is metadata reporter?
Teradata 
