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
- 10238 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
Why do you use Mapping Parameter and mapping variable?
What are the different types of olap? Give an example?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is deployment group?
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain the mapping variable usage example in informatica
How can informatica be used for an organization?
What is persistent lookup cache?
What is the procedure for creating independent data marts from informatica 7.1?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the different components of powercenter?
What is a sorter transformation?
What are the advantages of informatica?
How can we use batches?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
