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
- 13007 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
Is it possible to create multiple domains on a single Informatica server?
Can you use flat files in Mapplets.
How does a sorter cache works?
Can we get 1st record through Informatica(without sequence number).
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Why union transformation is an active transformation?
What is an aggregator transformation?
What is the difference between a connected look up and unconnected lookup?
Why do you use Mapping Parameter and mapping variable?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
what is the -ve test case in your project.
Explain the different kinds of facts.
Differentiate between sessions and batches?
What is fact table? Explain the different kinds of facts.
What are the main issues while working with flat files as source and as targets ?
