How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answers were Sorted based on User's Feedback
Answer / g. manthiramoorthy
Create Two Port in Exp. Trans
v_temp : v_temp+1
o_seq : IIF(ISNULL(v_temp),0,v_temp)
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / kalyan
Do a lookup on the Target table with an Lookup SQl Override
Select MAX(FIELD_NAME), field 1 , field3 from target group
by field1, field2...
In the Expression increment the Max values of the field
which you just got from the lookup by 1.
Here MAX_FIELDNAME) is the Max value of the field you want
to generate the sequence of..
| Is This Answer Correct ? | 19 Yes | 4 No |
Answer / kamalakar
by using pre sql in source qualifier we can generate
sequence in the target
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / raghu
TAKE EXPRESSION TRANSFORMATION AND DOUBLE CLICK ON THE
EXPRESSION TRANSFORMATION AND ADD TWO NEW PORTS
1.SEQ
2.SEQ_OUT
1.IN THE SEQ PORT CHECK V=VARIABLEPORT THERE YOU MENTION
EXPRESSION SEQ+1.
2.IN THE SEQ_OUT PORT CHECK O=OUTPUTPORT THERE YOU MENTION
EXPRESSION IIF(ISNULL(SEQ),O,SEQ)
IT WILL GIVE CORRECT RESULT
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / kishore.g.n
It can be implemented throuh Lookup T/f,Develope the lkp
t/r with condition like NEXTVAL=CURVAL+1,Through this
conditon we can acheive.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / infastudent
use an oracle sequence and create a function to call it
inside informatica
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / m
Take Two Variable Ports in Expression V1,V2 and Output Port
V1=V2
Op=v1
V2=V1+1
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sathish
use expression transformation
create two ports
one is assigned with it to zero
another one is assigned in outputport with expression logic
is o_seq=v_seq+1;
| Is This Answer Correct ? | 9 Yes | 7 No |
Answer / arnab
either use oracle to generate the sequence number or use an
unconnected lkp transformation which looks up on the
target, get the max(value) of the column which has to be
incremented and increment the value by 1
| Is This Answer Correct ? | 0 Yes | 2 No |
What is the default join that source qualifier provides?
what is the incremental agrrigation?
Major difference between SQL override and Lookup Sql override
what is the difference between mapplet & stored procedure?
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
What are the tasks that can be performed using sq?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Write the advantages of partitioning a session?
What is Session and Batches?
hw cn v elimate dublicate values from lookup without overriding sql?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
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?