Differentiate between mapping parameter and mapping variable?
Answer / ysindhureddy77@gmail.com
A mapping parameter is a user definable constant that takes up a value before running a session. It can be used in SQ expressions, Expression transformation etc.
A mapping variable is also defined similar to the parameter except that the value of the variable is subjected to change. It picks up the value in the following order.
From the Session parameter file
As stored in the repository object in the previous run
As defined in the initial values in the designer
Data type Default values
| Is This Answer Correct ? | 0 Yes | 0 No |
what is galaxy repository?
How can you differentiate between powercenter and power map?
without table how to come first record only in oracle?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
Explain the flow of data in Iinformatica?
version controlling in informatica?
In which circumstances that informatica server creates Reject files?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
I want load the data into target with out 1st and last record.
What is the difference between normal and bulk loading? Which one is recommended?
What is parameter file?