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



3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's ..

Answer / 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

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's ..

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

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's ..

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

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's ..

Answer / mukesh

write logic of seq gen. in a procedure and Use store proc
transformation.

Is This Answer Correct ?    0 Yes 0 No

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's ..

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

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's ..

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

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's ..

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

Post New Answer

More Informatica Interview Questions

What are the join types in joiner transformation?

1 Answers   Informatica,


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,


What are the Advantages of de normalized data?

3 Answers  


what type of problem you faced insales project or insurance project

1 Answers   Sony,


How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,






Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  


What are multi-group transformations?

0 Answers   Informatica,


What is the Rank index port in Rank transformation?

0 Answers   Informatica,


What is Index Caches size?

0 Answers   Informatica,


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

0 Answers  


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?

1 Answers   IBM,


What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  


Categories