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 / 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 |
Post New Answer View All Answers
Explain how to import oracle sequence into informatica?
Describe an informatica powercenter?
What is the need of an ETL tool?
How to join three sources using joiner? Explain though mapping flow.
what are the Methods For Creating Reusable Transformations?
Is it possible to create multiple domains on a single Informatica server?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Enlist few areas or real-time situations where informatica is required.
What is the different lookup cache(s)?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Difference between Data and Index Caches?
What is the benefit of partitioning a session?
How to partition the Session?
What are the differences between joiner transformation and source qualifier transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.