What are mapping parametres and variables in informatica?
Answer Posted / raja
mapping parametres is constant value it should defines in
separately using mapping parametres create function provided
informatica server,
it use to create name,type,datatype,precision,scale.
mapping variable should varied when the each tome session
runs,it also use to create
name,type,precision,scale,aggreation.
it mainlyuse full for incremental load processing
| Is This Answer Correct ? | 5 Yes | 15 No |
Post New Answer View All Answers
How do you migrate data from one environment to another?
What the difference is between a database, a data warehouse and a data mart?
What is a difference between complete, stop and abort?
How many dimensions are there in informatica?
Difference between Target-based loading and constraint-based loading?
What is a joiner transformation and why it is an active one?
What is the need of etl tools?
What could be the possible resons of locks by user?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Differentiate between source qualifier and filter transformation?
What is session task and command task?
What is blocking transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Where do we use mapping variables in informatica?