Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12487 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
Can anyone tell me the new features in Informatica 9 Version?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What are the guidelines to be followed while using union transformation?
Explain dynamic target flat file name generation in informatica
What are the transformations that are not supported in mapplet?
What is DR strategy for Informatica project?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Reusable transformation and shortcut differences
What is session task and command task?
What are the designer tools for creating transformations?
What is a difference between complete, stop and abort?
How you can differentiate between connected lookup and unconnected lookup?
What is the use of code page?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain the use of aggregator cache file?
