How are parameters defined in informatica?
Answers were Sorted based on User's Feedback
parameters are defined in a mapping parameter/variables wizard.we can pass the values to the parameter outside the mapping without disturbing the design of mapping,but parameters are constant,until and unless user changes
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jagan
Value of mapping parameter remain constant for a session run. Server reads its value on every run from parameter file. its value can not be changed at the time of session execution. When ever next time session runs, it reads the parameter value again from parameter file.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / upendra
mapping parametrs are constant, if we define the mapping parameters and variable to mapping tab on menu bar, it used to every time we can run session edit the parameter file, we cant disturb mapping in design
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the drillup & drill down?and use of the drill up and drill down?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
If I have a index defined on target table and if set it to bulk load will it work ?
What is predefined event?
what is the purpose of surrogate key and diff between primary key&surrogate key
How do you join more than 3 flat files in informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
Target increases every day even though no new record was inserted
What differs when we choose the sorted input for aggregator transformation?
How to identify this row for insert and this row for update in dynamic lookup cache
what is fact table?