what is curr val use for in sequence generator?

Answers were Sorted based on User's Feedback



what is curr val use for in sequence generator?..

Answer / sree

CURR_VAL is NEXT_VAL plus incermentby value.

Is This Answer Correct ?    3 Yes 5 No

what is curr val use for in sequence generator?..

Answer / ramesh

The current value is used when we enable the recycle option in sequence generator. The current value is the starting value for the next cycle.
Ex: if we enable cycle and current value as 3 and end value as 20, then the next cycle starts from 3 after 20.

Let me know if i am wrong on ramesh.kom@hotmail.com

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More Informatica Interview Questions

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,


what are objects in data warehouse?

2 Answers   Mind Tree,


Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,


What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,


What are the join types in joiner transformation?

1 Answers   Informatica,






How to start a workflow using pmcmd command?

0 Answers  


What are conformed dimensions?

1 Answers  


What is InformaticaPowerCenter?

0 Answers   Informatica,


we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,


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,


can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,


List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  


Categories