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
- 10079 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
how many types of dimensions are available in informatica?
What is decode in static cache?
What is the function of look up transformation?
What does command task mean?
What is event and what are the tasks related to it?
What is a filter transformation and why it is an active one?
What is the difference between source qualifier transformations source filter to filter transformation?
tell me the rules and responsblites in our project(my project is development)
What is Cognos script editor?
What is a difference between complete, stop and abort?
Define joiner transformation?
How to elaborate powercenter integration service?
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.
State the limitations where we cannot use joiner in the mapping pipeline?
What is a joiner transformation?
