what is curr val use for in sequence generator?

Question Posted / mehul.thakur

2 Answers
7577 Views
Emphasis, I also Faced
E-Mail Answers

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

explain different types of modeling.

2 Answers

What are Target Options on the Servers?

1 Answers

what is sql override?what is the use of it?

4 Answers Sonata,

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers L&T,

In dimension and fact table? which one holds big data?

2 Answers

design of staging area?

0 Answers

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers

How will you update the row without using update statergy?

10 Answers CTS,

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers Cap Gemini, Target,

Does Facttable Normalized or Denormalized?

2 Answers IBM,

For more Informatica Interview Questions Click Here