Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / pendekanti praveen kumar

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design time, run time. If you don't create parameter what will happen

1604

What are the restrictions of union transformation?

767

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1786

Differentiate between a database and data warehouse?

874

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1264




What are the tasks that can be performed using sq?

797

What is a sorter transformation?

863

How you can differentiate between connected lookup and unconnected lookup?

804

can we override a native sql query within informatica? Where do we do it? How do we do it?

803

What is informatica etl tool?

718

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10427

Explain pushdown optimization and types in informatica

825

What do you mean by enterprise data warehousing?

812

Define mapplet?

784

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9292