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???
- 3 Answers
- 7704 Views
- HP, I also Faced
- E-Mail Answers
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 is a repository? And how to add it in an informatica client?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What can we do to improve the performance of informatica aggregator transformation?
how we can load rejected record's at run time?(not through bad files)
What is the need of an ETL tool?
What is deployment group?
What is the surrogate key?
Implementation methodology
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are data-driven sessions?
What is the sql query overwrite in source qualifier in informatica
Explain target update override in informatica
What is informatica?
what are the Methods For Creating Reusable Transformations?
