How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vijay
You can also use expression transformation. Write the logic
i = 0 and increment it in another column. Give this column
as output.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the new features of Power Center 5.0?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
how to through logic of informatica using the push down optimization into oracle.
What is union transformation in informatica?
can we see default group,when we use router?if yes how?
Define mapplet?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
can we override a native sql query within informatica? Where do we do it?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How can u work with remote database in informatica?did you work directly by using remote connections?