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
Have you worked with/created Parameter file
lookup transformation with screenshots
Enlist few areas or real-time situations where informatica is required.
Why update strategy and union transformations are active? Explain with examples.
What is the way to execute pl/sql script using informatica mapping?
What is a passive transformation?
What is Cognos script editor?
What is a filter transformation?
How many transformations can be used in mapplets.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Tell me about MD5 functions in informatica
Difference between Data and Index Caches?
What is an Integration service in Informatica?
What is the difference between Active and Passive transformation?
What is workflow? What are the components of workflow manager?