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
Tell me about MD5 functions in informatica
What is sq transformation?
can we override a native sql query within informatica? How do we do it?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain pushdown optimization and types in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is decode in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is $$$$?
Explain the different lookup methods used in informatica?
How union transformation is used?
What are the conditions needed to improve the performance of informatica aggregator transformation?
what is mean by complex business rule ?
What is Index Caches size?
What is domain in terms of informatica?