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
- 10286 Views
- I also Faced
- E-Mail Answers
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
Differentiate between a repository server and a powerhouse?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is pmcmd command?
What is the benefit of session partitioning?
What is a passive transformation?
What are the differences between source qualifier and joiner transformation?
Why do you use Mapping Parameter and mapping variable?
COM components can be used in Informatica
What is an aggregator transformation?
Difference between Target-based loading and constraint-based loading?
Explain in detail about scd type 1 through mapping.
How can informatica be used for an organization?
How does a rank transform differ from aggregator transform functions max and min?
What are the advantages of using informatica as an etl tool over teradata?
