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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are active and passive transformations?

658


To import the flat file definition into the designer where should the flat file be placed?

682


What is confirmed fact in dataware housing?

5703


What is meant by pre and post session shell command?

634


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5861






Separate from a database, an information bazaar, and an information stockroom?

615


what are factless facts? And in which scenario will you use such kinds of fact tables.

1322


What are the different types of transformation available in informatica.

644


What do you understand by SOA of Informatica?

594


What is lookup change?

626


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

662


Clarify the aggregator change?

605


What is a dimensional model?

587


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1629


Define filter transformation?

630