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


Please Help Members By Posting Answers For Below Questions

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1638


What is aggregator transformation in informatica?

545


What do you mean by enterprise data warehousing?

649


Enterprise data warehouse your projects phase by phase explain?

1473


If informatica has its scheduler why using third party scheduler?

778






COM components can be used in Informatica

1877


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1789


How to create the source and target database connections in server manager?

634


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1540


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055


What is the use of target designer?

611


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4793


Why filter transformation is an active one?

565


What is aggregate cache in aggregator transformation?

637


How to generate sequence numbers?

620