Interested to Buy Any Domain ? << Click Here >> for more details...
how do u use sequence created in oracle in informatica?
Explain with an simple example
- 6 Answers
- 20425 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / sujay
by writing sql override in the source qualifier by calling
sequence which you have created in oracle
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
in reporting we add some new objects,how we get the count of the newly added objects to the report
explan ur project architecture?
What are roles and groups and benefits of using them?
What is a predefined event?
Briefly define a session task?
How to join three sources using joiner? Explain though mapping flow.
What are the different options available for update strategy?
How do you load only null records into target?
Explain the mapping variable usage example in informatica
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain incremental aggregation in informatica
What is the use of transformation?
What is rank transformation in informatica
