How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).
Answer Posted / manikandan
I think your Express increment is not clear because when the second record will comes again it that variable is initialize to zero.
So we do to capture into Variable by SetVariable()
Or
The Use target lookup and return the column(SNo) which you what to populate the seq number.
Check in Express(before Target), If(isNull(SNo), 1, SNo+1). Connect this to SNo in Target
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the commit type if you have a transaction control transformation in the mapping?
Explain the shared cache and re-cache?
What are the different types of repositories created using informatica?
How to extract the informatica rejected data?
What is a predefined event?
In how many ways we can create ports?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the need for an etl tool?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What do you understand by term role-playing dimension?
Briefly define reusable transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the components of the workflow manager?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
have u done any performance tuning? how u ll do?