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?
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 |
What are the join types in joiner transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What are the Advantages of de normalized data?
what type of problem you faced insales project or insurance project
How we will implement Pushdown Optimization and Types in Informatica with better examples
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
What are multi-group transformations?
What is the Rank index port in Rank transformation?
What is Index Caches size?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
What does “tail –f” command do and what is its use as an Informatica admin.