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
- 10449 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
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a predefined event?
How to load data in informatica ?
What is flashback table ? Advance thanks
Why do you use Mapping Parameter and mapping variable?
What are the differences between oltp and olap?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What you know about transaction control transformation?
what is degenerated dimension?
can u any challenge your project?
What are the types of presistent cache in look up tr.
What are the different transaction levels available in transaction control transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What's the layout of parameter file (what does a parameter file contain?)?
