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
- 12806 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
Differentiate between joiner and lookup transformation?
What is union transformation in informatica?
How to handle decimal places while importing a flatfile into informatica?
What is resilience time?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain what are the different versions of informatica?
How can you increase the performance in joiner transformation?
What is a joiner transformation?
Explain the different lookup methods used in informatica?
What is an expression transformation?
How to extract sap data using informatica?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How many ways are there to do 'remove duplicate records in informatica'?
What is the format of informatica objects in a repository?
