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

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,


What is the default join that source qualifier provides?

3 Answers   Informatica,


what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,


What you know about transaction control transformation?

0 Answers  


Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  






following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,


How to do the error handling of if ur source is flatfiles?

0 Answers  


i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,


i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,


How do you load first and last records into target table?

0 Answers  


Categories