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 if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,


What is the default source option for update stratgey transformation?

1 Answers  


How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,


in which situations do u go for sequence generator ?

2 Answers   TCS,


What is the need of etl tools?

0 Answers  






how can u load the data in time dimension?

3 Answers  


How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,


In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,


What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  


Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  


In which transformation you cannot drag ports into it?

0 Answers   Informatica,


What is the need of building a data warehouse?

2 Answers  


Categories