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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create a node as a gateway node and the same node can be assigned to a grid?

1085


What is the difference between router and filter?

1277


What is flashback table ? Advance thanks

1945


What are the tasks that can be performed using sq?

1096


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

978


How do you load only null records into target?

1221


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2191


What are connected or unconnected transformations?

1128


Explain transaction control transformation in informatica

1275


What are the static cache and dynamic cache in informatica?

1198


What is the status code in stored procedure transformation?

1185


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1131


What are the main issues while working with flat files as source and as targets ?

1168


What is blocking transformation?

1152


Under what condition selecting sorted input in aggregator may fail the session?

1128