Where do you create/define mapping parameter and mapping variable?
Answer / rajesh kumar
We can create mapping parameters and variables in mapping designer/mapplet designer.
We can define the value within the transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you load unique records into one target table and duplicate records into a different target table?
What is Index Caches size?
why union transformation is active transformation?
How can you recover the session in sequential batches?
What is a predefined event?
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
What is polling in informatica ?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
what is sql override?what is the use of it?
How the dimensions will be loaded?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?