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 / krishnam
If the MP or MV is not defined then infa server will take
the default values. The order is: First it will serch in
Parameter file for the values, then repository( in case of
MV), if the value is not found then it will look for
initial value. If it can not find the value it will take
default values.
| Is This Answer Correct ? | 25 Yes | 3 No |
Post New Answer View All Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What's the layout of parameter file (what does a parameter file contain?)?
Plz can any one say me how to get the informatica certification materials and dumps
Is it possible to revert a global repository to local one and why?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Can you use flat files in Mapplets.
What are the tasks that source qualifier perform?
What are the settings that you use to configure the joiner transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the differences between joiner transformation and source qualifier transformation?
What is dimensional table? Explain the different dimensions.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is flashback table ? Advance thanks
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Under what conditions selecting sorted input in aggregator will still not boost session performance?