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 recover sessions in concurrent batches?
Three date formats are there . How to change these three into One format without using expression transformation ?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
Explain sql transformation in script mode examples in informatica
What is the default join that source qualifier provides?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is joiner transformation in informatica?
how to we create datamart?
how to import multiple flat files in to single target where there is no common column in the flat files
How might you approve all mappings in the archive all the while?