gazulas

 Profile Answers by gazulas Questions by gazulas

• Jan 29th, 2006

 

in designer u will find the mapping parameters and variables options.u can assign a value to them in designer. comming to there uses suppose u r doing incremental extractions daily. suppose ur source system contains the day column. so every day u have to go to that mapping and change the day so that the particular data will be extracted . if we do that it will be like a layman's work. there comes the concept of mapping parameters and variables. once if u assign a value to a mapping variable then it will change between sessions.

madhu sudhan rao

• Feb 18th, 2006

 

mapping parameters and variables make the use of mappings more flexible.and also it avoids creating of multiple mappings. it helps in adding incremental data.mapping parameters and variables has to create in the mapping designer by choosing the menu option as Mapping ----> parameters and variables and the enter the name for the variable or parameter but it has to be preceded by $$. and choose type as parameter/variable, datatypeonce defined the variable/parameter is in the any expression for example in SQ transformation in the source filter prop[erties tab. just enter filter condition and finally create a parameter file to assgn the value for the variable / parameter and configigure the session properties. however the final step is optional. if ther parameter is npt present it uses the initial value which is assigned at the time of creating the variable