Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ??

Answers were Sorted based on User's Feedback



How could we generate the sequence of key values without using sequence generator transformation i..

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

How could we generate the sequence of key values without using sequence generator transformation i..

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

How could we generate the sequence of key values without using sequence generator transformation i..

Answer / kamalakar

by using pre sql in source qualifier we can generate
sequence in the target

Is This Answer Correct ?    16 Yes 3 No

How could we generate the sequence of key values without using sequence generator transformation i..

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

How could we generate the sequence of key values without using sequence generator transformation i..

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

How could we generate the sequence of key values without using sequence generator transformation i..

Answer / infastudent

use an oracle sequence and create a function to call it
inside informatica

Is This Answer Correct ?    8 Yes 4 No

How could we generate the sequence of key values without using sequence generator transformation i..

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

How could we generate the sequence of key values without using sequence generator transformation i..

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

How could we generate the sequence of key values without using sequence generator transformation i..

Answer / sureshbabu

raghu is correct

Is This Answer Correct ?    1 Yes 1 No

How could we generate the sequence of key values without using sequence generator transformation i..

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

Post New Answer

More Informatica Interview Questions

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  


What is tracing level and what are the types of tracing level?

2 Answers   TCS,


I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,


what are the row and column separations in Flat Files

3 Answers   CTS,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


Separate from a database, an information bazaar, and an information stockroom?

0 Answers  


What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,


A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  


What is active and passive transformation?

10 Answers  


If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,


how to remove staging area

1 Answers  


what is mapping optimization? wat are the techniques for tat

2 Answers  


Categories