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
- 10451 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
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to use pmcmd utility command?
what are the deliverables?in your project?
Enlist the differences between database and data warehouse.
Explain lookup transformation source types in informatica
Why update strategy and union transformations are active? Explain with examples.
what is the Default Source Option For Update Strategy Transformation?
is it possible to index the data in cache of lkp transformation ?
How can one identify whether mapping is correct or not without connecting session?
What are the tasks that source qualifier perform?
Where is metadata stored?
What is joiner change?
What is the difference between STOP and ABORT options in Workflow Monitor?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is the need for an etl tool?
