Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9057 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jz
If you want Oracle seq then go for SQL t/r in query mode. In
that write a query ( select Sequence_name from dual) in o/p
port. You will get your result.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
What are the differences between joiner transformation and source qualifier transformation?
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
What is rank index in rank transformation?
What are the types of maping in Getting Started Wizard?
What is the difference between informatica 7.0 and 8.0?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
How to recover the standalone session?
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
What is workflow monitor?
Explain the pipeline partition with real time example?
Teradata 
