1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Explain about the concept of mapping parameters and
variables ?

Question Posted / guest

Answers were Sorted based on User's Feedback



Explain about the concept of mapping parameters and variables ?..

Answer / neena

Mapping parameters represents a constant value that we cant
change during the seesion run.

Mapping variables represents a value that we can change
during the seesion run.

Is This Answer Correct ?    10 Yes 0 No

Explain about the concept of mapping parameters and variables ?..

Answer / manju

Mapping parameters s a constant value and mapping variables
will change in the mapping.It is mainly usefull for
incremental load processing

Is This Answer Correct ?    3 Yes 0 No

Explain about the concept of mapping parameters and variables ?..

Answer / rekha

MAPPING PARAMETERS :
MAPPING PARAMETERS REPRESENT A CONSTANT VALUE AND DOES NOT
CHANGE DURING THE SESSION
MAPPING REUSABILITY CAN BE ACHEIVED

MAPPING VARIABLE REPRESENTS A VALUE THAT CHANGE THE VALUE
DURING THE EXECUTION FROM INITIAL VALUE TO THE FINAL VALUE
MAPPING VARIABLES USE IN INCREMENTAL LOAD PROCESS

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

what is the process of target load planing?

2 Answers   IBM,

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,




a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

can you use flat file for repository?why?

2 Answers   TCS,

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

Could any one to tell Fact table Partitioning?

2 Answers  

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

For more Informatica Interview Questions Click Here
Categories