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 can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).


Answers were Sorted based on User's Feedback



How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Tr..

Answer / krishna

Use database Sequence generator call this from stored
procedure or dummy lookup query

or

You can also use expression transformation. Create two
ports one is variable and assign it to 0 and another one is
output port ind Write the logic to increment it
(o_seq=v_Seq+1)

Is This Answer Correct ?    9 Yes 1 No

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Tr..

Answer / vijay

You can also use expression transformation. Write the logic
i = 0 and increment it in another column. Give this column
as output.

Is This Answer Correct ?    7 Yes 1 No

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Tr..

Answer / manikandan

I think your Express increment is not clear because when the second record will comes again it that variable is initialize to zero.

So we do to capture into Variable by SetVariable()

Or

The Use target lookup and return the column(SNo) which you what to populate the seq number.

Check in Express(before Target), If(isNull(SNo), 1, SNo+1). Connect this to SNo in Target

Is This Answer Correct ?    3 Yes 0 No

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Tr..

Answer / chaitanya

Use database Sequence generator

Is This Answer Correct ?    2 Yes 0 No

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Tr..

Answer / ganesh

You can handed this issue, using expression transformation.

1) create one variable port and declare it as Integer and
assign the value to Output port.

e.g: var_count Integer var_count+1
out_count Integer var_count

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

Where do you create/define mapping parameter and mapping variable?

1 Answers  


For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  


How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,


"Change cache" in Informatica ?

2 Answers  


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

0 Answers   Patni,


Can we create a Integration service without a Repository service and vice versa?

0 Answers  


What is sq transformation?

0 Answers  


I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,


Describe expression transformation?

0 Answers  


what is bridge tables in informatica

1 Answers   CTS,


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers  


Categories