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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

hi talents,
how do u get sequece numbers with oracle sequence generator
function in informatica.... i dont need to use sequence
generator transformation..... how do u achieve this???

Question Posted / baladevshree

Answers were Sorted based on User's Feedback



hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.....

Answer / jz

If you want Oracle seq then go for SQL t/r in query mode. In
that write a query ( select Sequence_name from dual) in o/p
port. You will get your result.

Is This Answer Correct ?    6 Yes 0 No

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.....

Answer / santosh kumar sarangi

you can use the mapping variable with datatype as integer
and aggregation type as count. So for every row it will
generate the number.

Is This Answer Correct ?    0 Yes 1 No

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.....

Answer / sukanta

You can call the DB sequence generator in the source
qualifier override sql query.Generate sql query first,add
the SG name in the sql query and alias as a port exist in
database table.

You will get the solution.I check it.

Regards
Sukanta

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

What is deployment group?

0 Answers  

What is sequence generator transformation in informatica?

0 Answers  

What is a surrogate key?

0 Answers  

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

What are the basic needs to join two sources in a source qualifier?

4 Answers  

List the transformation in informatica.

1 Answers   TCS,

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

For more Informatica Interview Questions Click Here
Categories