In incremental loading using Mapping variable if session
failed with any of reason in the middle of process. is the
Mapping variable remains constant or change?
Answer / subhankar chatterjee
Mapping Variable will store its value in the repository once the Session run successfully.If the session fails the Mapping Variable will not be updated with the new value.
| Is This Answer Correct ? | 40 Yes | 1 No |
Quickly characterize reusable change?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
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?
what are the row and column separations in Flat Files
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?
What are the modules in Power Center
 Code page compatibly –Where all changes are made to handle the scenario.
WHAT IS FACT TABLES?
Define Pmrep command?
Explain the different lookup methods used in informatica?
What are active transformations? Name them.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?