Interested to Buy Any Domain ? << Click Here >> for more details...
How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).
- 5 Answers
- 10291 Views
- I also Faced
- E-Mail Answers
Answer Posted / krishna
Use database Sequence generator call this from stored
procedure or dummy lookup query
or
You can also use expression transformation. Create two
ports one is variable and assign it to 0 and another one is
output port ind Write the logic to increment it
(o_seq=v_Seq+1)
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
can anyone explain me about retail domain project in informatica?
What is mapping debugger?
What is a passive transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain your project of banking domian.
What is intricate mapping?
define galaxy repository in informatica
Tell me about Propagate functions in informatica
What are multi-group transformations?
How are the sources and targets definitions imported in informatica designer?
Explain the use of aggregator cache file?
Explain how to import oracle sequence into informatica?
Which development components of informatica have the highest usage?
what is the Default Source Option For Update Strategy Transformation?
What is sorter transformation?
