What will happen when Mapping variable and Mapping parameter
is not defined or given?
Where do you use mapping variable and mapping parameter?
Answer Posted / nagaraju bhatraju
If Mapping Parameter or variable is not defined in
parameter file session will fail, but if default value is
defined at , then session will take those default values.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is a rank transform?
How to load a Dimension ? and how to load a fact table?
Is it possible to define a single node as a Gateway node as well as worker node?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain sessions and how many types of sessions are there?
Differentiate between joiner and lookup transformation?
Which development components of informatica have the highest usage?
Name the different lookup cache(s)?
What is the format of informatica objects in a repository?
Describe data concatenation?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the components of Informatica? And what is the purpose of each?
How to generate sequence numbers?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?