hi talents,
how do u get sequece numbers with oracle sequence generator
function in informatica.... i dont need to use sequence
generator transformation..... how do u achieve this???
Answer Posted / santosh kumar sarangi
you can use the mapping variable with datatype as integer
and aggregation type as count. So for every row it will
generate the number.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the use of an aggregator cache file?
lookup transformation with screenshots
Can you generate sequence numbers without using the sequence generator transformation?
What is informatica metadata and where is it stored?
How to improve the performance of a session using sorter transformation?
How we can use union transformation?
How to elaborate tracing level?
Explain what are the different types of transformation available in informatica.
Explian the Process of deployment groups in informatica
How to load a Dimension ? and how to load a fact table?
What are ETL Tools?
Clarify the utilization of aggregator cache record?
What is sq transformation?
what is informatica metadata?