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
- 10574 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / bebbo
in the properties window of seq. gen you can either select
reset or cycle option to avoid the above situation...
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / bebbo
in the properties window of seq. gen you can either select
reset or cycle option to avoid the above situation...
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mukesh
write logic of seq gen. in a procedure and Use store proc
transformation.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shridhar
We can use one more sequence generator after that sequence
generator or get the value of max key in unconnected lookup
tx and call that value in expression tx and add +1 to the
value and send to the next tx.
Thanks
Shridhar
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / itsranjan
In properties window of sequence generator one can select
reset or cycle option to avoid such kind of situations.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / vijaykumar
Session will not fail if it reaches the maximum default
value. The Integration Services Automatically reset the
value and it's start from 1.
| Is This Answer Correct ? | 2 Yes | 6 No |
how do u move the code from development to production?
what is the size of u r source(like file or table)?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
how eliminate the duplicates in flat file with out using sorter ,aggregater
Explain in detail scd type 2 through mapping.
What are events in workflow manager?
Define mapplet?
what are the settiings that u use to cofigure the joiner transformation?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
Explain about the concept of mapping parameters and variables ?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
without dynamic lookup transformation how to insert new rows and update existing rows?
Teradata 
