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 |
Briefly explain the aggregator transformation?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
What is decode in static cache?
Enlist the tasks for which source qualifier transformation is used.
What all join we can perform in LOOKUP transformation?
why we use informatica in our project?
What is joiner cache?
what is datamart
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
what is lookup ?
How can we store previous session logs?
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????