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
- 8891 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / sukanta
You can call the DB sequence generator in the source
qualifier override sql query.Generate sql query first,add
the SG name in the sql query and alias as a port exist in
database table.
You will get the solution.I check it.
Regards
Sukanta
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How identifying bottlenecks in various components of informatica and resolving them?
How to partition the Session?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
how many types of dimensions are available in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Can we get 1st record through Informatica(without sequence number).
Which files are created during the session rums by informatics server?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is a stored procedure transformation?
Explain what are the different types of transformation available in informatica.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Where are the source flat files kept before running the session?
Explain the different lookup methods used in informatica?
