3. Suppose Seq Gen is supplying a increamental value to a column
of a table, suppose, table's column value reaches to maximum
value, then what will happen, will the session fail? If it is the
situation, then what should be done so that we can stop this kind
of situation in advance?
- 7 Answers
- 10514 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / inon ismat
Yes, the Sequence generator will reset but there is a
possiblity of session failure. Lets say for the sake of
argument after seq reset initial value is 1. One of the
possible situation for session failure is that if the
sequence generator is feeding any column that has PK or SK
or Unique Index on the target table and the initial value
after reset i.e., in our scenario it's 1 exist in the table
then the session will fail with Database violation error.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is a joiner transformation?
How to extract sap data using informatica? What is abap? What are idocs?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Define joiner transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are junk dimensions?
What is InformaticaPowerCenter?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How can a transformation be made reusable?
Explain pmcmd command usage in informatica
What can we do to improve the performance of informatica aggregator transformation?
Describe expression transformation?
In informatics server which files are created during the session rums?
Differences between connected and unconnected lookup?
Make a note of the quantity vaults made in informatica?
