In real time scenario where can we use mapping parameters
and variables?

Answers were Sorted based on User's Feedback



In real time scenario where can we use mapping parameters and variables?..

Answer / pendekanti praveen kumar

Before using mapping parameters and mapping variables we
should declare these things in mapping tab of mapping
designer.

A mapping parameter cannot change untill the session has
completed unless a mapping variable can be changed in
between the session.

Example:::
if we declare mapping parameter we can use that parameter
untill completing the session,but if we declare mapping
variable we can change in between sessions.Use mapping
variable in Transcation Control Transformation......

Is This Answer Correct ?    40 Yes 7 No

In real time scenario where can we use mapping parameters and variables?..

Answer / bsgsr

mapping variable unlike mapping parameter changs its value
during session execution. it is used in incremental loading.

parameters are used in many scenarios like loading the data
of employees who joined ina particular year, for
timestamping, loading the data related to a particular
product id. alike.

if i am wrong let me know.
bsgsr12@gmail.com

Is This Answer Correct ?    21 Yes 3 No

In real time scenario where can we use mapping parameters and variables?..

Answer / ram kumar

Mapping & Mapplet, v can use the mapping parameter &
variable. V can also create the parameter & variable in the
sesssion level.

Is This Answer Correct ?    31 Yes 23 No

In real time scenario where can we use mapping parameters and variables?..

Answer / kittu

Before using mapping parameters or variables first we hav to declare them in mapping level.After that we can create parameter file with .txt or .prm extension . Mapping parameters are used when the requirement need the values that cannot change with in session where as mapping variables can change the value with in session the best example for mapping variable are we can use them in concept of Increamental Loading and also to generate sequence numbers with out using sequence Generator Transfomation.

Is This Answer Correct ?    7 Yes 4 No

Post New Answer

More Informatica Interview Questions

How can you validate all mappings in the repository simultaneously?

0 Answers  


How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,


why u go for dimensions ?

3 Answers   TCS,


Why is sorter an active transformation?

0 Answers  


Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,


1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,


What is polling in informatica ?

1 Answers   TCS,


What is the way to execute pl/sql script using informatica mapping?

0 Answers  


what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,


While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,


how to load duplicate row in a target

4 Answers  


scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,


Categories