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 union transformation is used?

0 Answers  

How many joins in Informatica

5 Answers   CSC,

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

4 Answers  

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

how to move the mappings from your local machine to claint place?

2 Answers  

What are the different types of Type2 dimension maping?

1 Answers  

What is a predefined event?

0 Answers  

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

waht is dataware house

2 Answers  

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

What is target update override

2 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories