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 |
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.
What is the default join that source qualifier provides?
what is persistant cache in which situation we will use persistantcache
What you know about transaction control transformation?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
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?
How to do the error handling of if ur source is flatfiles?
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
i have two source data there is no pk,fk how to join the two sources
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
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
How do you load first and last records into target table?