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 ??

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica? Why do we need it?

1101


write a query to retrieve the latest records from the table sorted by version(scd)

1068


Which means the first record should come as last record and last record should come as first record and load into the target file?

1080


can we override a native sql query within informatica? How do we do it?

1126


Can anyone tell me the new features in Informatica 9 Version?

2129


What is the different lookup cache(s)?

1086


What can we do to improve the performance of informatica aggregator transformation?

1095


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1294


How will the document be delivered to me?

1085


Enlist the tasks for which source qualifier transformation is used.

1040


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1049


What do you mean by worklet?

1065


What are the types of schemas we have in data warehouse and what are the difference between them?

942


How do you load first and last records into target table?

1159


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9827