In seqence generator transformation maximum limit is
reached,after reaching maximum limit how will u insert the
data
- 2 Answers
- 10866 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sarangi
If sequence generator reached the maximum limit and can't
increase then do as follows.
1. Reset sequence generator to 0
2. Add a expression transformation make an out put port
Out_put_port= max_val_previous_sequence_gen+new_current_val
In this case you can generate next max value.
Let me know if any things wrong.
Thanks $ Regards
Santosh Kumar Sarangi
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain Dataware house architecture .how data flow from intial to end?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Separate from an archive server and a powerhouse?
What is persistent lookup cache?
What are the different versions of informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you use reject loader.
What is the reusable transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is informatica etl tool?
expain about the tune parameters?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
