What is the difference Between Mapping parameter and variable
Answers were Sorted based on User's Feedback
Answer / siva
In additon to the Abhinav answer, Once value assigned to
mapping parameter, it can not be change as per login in
mapping.
Where as if you define as mapping variable, it can be
initialized, can be changed the value as per logic in
mapping and even it can be held as persistent to use the
same value in running session next time.
I think you understand this..
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / abhinav
Mapping parameter is an option in Informatica where, at the
mapping level, you can specify the value to be used.
For example, if there is a field called START_DATE, the
value for this date can be specified by either passing it
as a variable at the mapping level or storing the value in
a parameter file, which will be read during the session is
run.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sankar
mapping parameter: maping parameter is a constent value
that can be defin before maping run
A mapping parameter reuse the mapping for various constant
value.
mapping variable:mapping vareable is represent a value that
can be change during the mapping run
that can be stored in reposatry the integartion service
retrive that value frm repositary and incremental value for
next run
Is This Answer Correct ? | 2 Yes | 1 No |
Two different admin users created for repository are ______ and_______
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
How will you update the row without using update statergy?
List the transformation in informatica.
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
What is meant by a domain?
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
how many session run unix environment what command using ?
how to create a sample mapping for dynamic lookup transformation
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?