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 are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain grouped cross tab?
How many dimensions are there in informatica?
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
Name the different lookup cache(s)?
How to load the source table into flat file target(with columns) in informatica?
In which scenario did you used pushdown optimization?
What is fact table? Explain the different kinds of facts.
What is the reusable transformation?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
difference between repository database and repository service?