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 |
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Write the different tools in the workflow manager?
Explain reference cursor?
scenario
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
How to configure mapping in informatica?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
what are the perameter and variable?
Why union transformation is an active transformation?
sample mappings for scd1,scd2 and scd3
sorce is a flatfile only 1st and last row should insert to target how will u do?