How can we reset Sequence Generator, when we move objects from Dev Environment

How can we reset Sequence Generator, when we move objects
from Dev Environment to QA env?

Question Posted / power_star

2 Answers
10947 Views
Rolta, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?..

Answer / dave

Update the current value in the sequence generator to start
the sequence from the beginning again. And V on reset option
in transformation

Is This Answer Correct ?

9 Yes

1 No

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?..

Answer / rajesh

while we migrate the code by import and export or by Deployment groups, then we will un-check the option retain persistant values.

Now all the values will be reset as new, like resetting SQgen values, Mapping variables ... etc will goes to initial vaules

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Informatica Interview Questions

Define maping and sessions?

3 Answers

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers

What is a unit Testing?

1 Answers

what is degenerated dimension table with scenario

2 Answers HCL,

What are the transformations that are not supported in mapplet?

0 Answers

Where is the cache stored in informatica?

5 Answers Infosys, Satyam,

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers

What are the types of maping wizards that r to be provided in Informatica?