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 / ramu

The above answer is correct and also set property like max
value is min value.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

612


What are the new features of Power Center 5.0?

1231


How to load a Dimension ? and how to load a fact table?

952


What does role playing dimension mean?

622


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6371






How can informatica be used for an organization?

650


What are connected or unconnected transformations?

627


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

604


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1846


What is rank transform?

595


What is the difference between informatica 7.0 and 8.0?

564


Can informatica load heterogeneous targets from heterogeneous sources?

694


Explain pushdown optimization $pushdownconfig parameter - informatica

700


What is sequence generator transformation in informatica?

617


What are the different types of transformation available in informatica.

634