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

major difference between normal loading and bulk loading?

6 Answers  

How informatica process data means how informatica works?

2 Answers   TCS,

What is a rank transform?

0 Answers  

why we r using presql&postsql in source qualifier?

1 Answers   HP,

What are the different ways to implement parallel processing in informatica?

0 Answers  

Explain the etl program with few examples.

0 Answers  

What are the ETL tools available in DWH?

6 Answers   Mphasis,

what is the predefined port in dynamic lookup

2 Answers  

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

8 Answers   HP,

Why filter transformation is an active one?

0 Answers  

What is informatica powercenter repository?

0 Answers  

For more Informatica Interview Questions Click Here
Categories