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 |
Explain the different lookup methods used in informatica?
What is the reusable transformation?
what is the difference between Informatica7.1 & informatica 8.1
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
Write the unconnected lookup syntax?
which one is better either active or passive transformation in informatica
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
Why do we use DSS database for OLAP tools?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
Can anyone tell me the new features in Informatica 9 Version?
What are the types of lookup?