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

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

What is the maplet?

0 Answers   Informatica,


What is the term PIPELINE in informatica ?

7 Answers   Deloitte,


my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,


what is mapping optimization? wat are the techniques for tat

2 Answers  


we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,






Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,


Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  


 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


what is upstream and downstream transformation?

7 Answers  


How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,


What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,


Can you copy the batches?

3 Answers  


Categories