Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,


Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,


suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,


There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,


If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,


what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,


On which transformations you created partitions in your project?

0 Answers   Cap Gemini,


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

0 Answers   Informatica,


How can you increase the performance in joiner transformation?

0 Answers  


what is SDLC way of code development?

0 Answers  


Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,


Categories