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 |
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).
What is the default source option for update stratgey transformation?
How can i set break points in debugging mode ? can explain steps please?
in which situations do u go for sequence generator ?
What is the need of etl tools?
how can u load the data in time dimension?
How we will implement Pushdown Optimization and Types in Informatica with better examples
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?
What is the difference between normal and bulk loading? Which one is recommended?
Can I create one wrkflw which will run different wrkflws on schedule time?
In which transformation you cannot drag ports into it?
What is the need of building a data warehouse?