Interested to Buy Any Domain ? << Click Here >> for more details...
How could we generate the sequence of key values without
using sequence generator transformation in the target ??
- 12 Answers
- 38539 Views
- TCS, Tech Mahindra, I also Faced
- E-Mail Answers
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 |
guys which is the best institute in banglore to learn informatica??
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the disadvantages of Sequence Generator T/R?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
How to send duplicates to one target and unique rows to one target?target is empty
what is the complex transformation you used in informatica
how DTM buffer size and buffer block size are related
Teradata 
