How mapping parameter and variable works
- 1 Answers
- 4397 Views
- I also Faced
- E-Mail Answers
Answer / abhinaw prakash
In Mapping parameter the value once defined does'nt change
during the session.Once the session completes successfully
the server again reads the data from the beginning.
In mapping variable the value changes during the session and
after the session completes the integration server reads the
data from the last saved value from the last run.
| Is This Answer Correct ? | 3 Yes | 0 No |
Define Incremental Aggregation?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
How to send duplicates to one target and unique rows to one target?target is empty
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
what is DSS?
how to move the mappings from your local machine to claint place?
What is lookup change?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
Enlist the various types of transformations.
In a concurrent batch if a session fails, can you start again from that session
What are the guidelines to be followed while using union transformation?
Teradata 
