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 |
if we have a delimiters at unwanted places in a flat file how can we over come those.
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
What are session parameters ? How do you set them?
What is power center repository?
What is facttable granularity?
what is the incremental agrrigation?
What is a command that used to run a batch?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
How to generate sequence numbers without using the sequence generator transformation?
what is data modelling? what are types of modelling?In which suituation will use each one?
What all are steps in up gradation of Informatica server?