how can u generate sequence of values in which target has
more than 2billion of records.(but with sequence generator
u can generate upto 2 biliion only)
Answer Posted / chinna
by using unconnected lookup transformation u can check
condtion ie counter >0 it will be allways true,
or you can use oracle sequence or stored procedure
u have any querries revert me on chinnadw@yahoo.com
Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is aggregator transformation in informatica?
What do you mean by enterprise data warehousing?
Enterprise data warehouse your projects phase by phase explain?
If informatica has its scheduler why using third party scheduler?
COM components can be used in Informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How to create the source and target database connections in server manager?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
pmscmd startworkflow -sv
What is the use of target designer?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Why filter transformation is an active one?
What is aggregate cache in aggregator transformation?
How to generate sequence numbers?