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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What do think which one is the better joiner or look up?

950


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1214


Explain scd type 3 through mapping.

757


What is parallel processing in informatica?

1267


Define update strategy?

810






What is the difference between stop and abort in informatica

855


How to call shell scripts from informatica?

739


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

868


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

801


What is the session task and command task?

764


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5153


Under which circumstances, informatica server creates reject files?

800


Can anyone tell me the new features in Informatica 9 Version?

1739


What are the databases that informatica can connect to windows?

780


Define filter transformation?

837