How can we reset Sequence Generator, when we move objects
from Dev Environment to QA env?
Answers were Sorted based on User's Feedback
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 |
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 |
How to load duplicate records in to a target table which has a primary key?
What are the types of metadata that stores in repository?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is deployemnt groups, Lables, query and dynamic deployment group.
What is the fact table?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
How union transformation is used?
explain about informatica server architecture?
HOW DO YOU CONNECT TO REMOTE SERVER ?
How to update or delete the rows in a target, which do not have key fields?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
Informatica settings are available in which file?