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 a connected look up and unconnected lookup?
What are the different types of repositories created using informatica?
Write the program through which the records can be updated?
Explain constraint based loading in informatica
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the types of presistent cache in look up tr.
What are the steps involved in the migration from older version to newer version of Informatica Server?
update strategy transformation in informatica
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is fact table? Explain the different kinds of facts.
What is Data Caches size?
is it possible to index the data in cache of lkp transformation ?
How to open an older version of an object in the workspace?
Explain lookup transformation in informatica