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
- 7988 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
Explain the tuning lookup transformation - informatica
Is there any way to read the ms excel datas directly into informatica?
How to handle decimal places while importing a flatfile into informatica?
What is the difference between Active and Passive transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the uses of etl tools?
which one is better performance wise joiner or look up
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is primary and backup node?
complex mapping ur project u r invlve can u explain and give real time example give me ?
