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
- 20383 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / nidhi
yes,Using stored procedure t/r we can do that..
I can give u brief idea.. i didnt tried this, sorry if it
goes wrong..
while writing the SP in oracle,we will call n execute the
existing sequence using execute immediate clause..
The o/p port of the SP t/r will be mapped to the sequence no
column in the target.
If i am wrong let me knw.. Thank you
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the types of caches in lookup? Explain them.
In development project what is the process to follow for an etl developer from day1
Write the prerequisite tasks to achieve the session partition?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the differences between joiner transformation and source qualifier transformation?
define galaxy repository in informatica
How to load a Dimension ? and how to load a fact table?
Differentiate between reusable transformation and mapplet.
design of staging area?
How do you load first and last records into target table?
How can you increase the performance in joiner transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How do you change a non-reusable transformation to reusable transformation?
what is the size of your data warehousing?
