Answer / vijay

Using Stored Porcedure Transformation we can call the
Sequence Generator

Answer / vijay

By using the Stored Procedure

please corect me if am wrong

Answer / sujay

by writing sql override in the source qualifier by calling
sequence which you have created in oracle

Answer / kishore

Using SQL transformation we can call the sequence in
informatica.

Answer / nidhi

yes,Using stored procedure t/r we can do that..

I can give u brief idea.. i didnt tried this, sorry if it
goes wrong..

while writing the SP in oracle,we will call n execute the
existing sequence using execute immediate clause..
The o/p port of the SP t/r will be mapped to the sequence no
column in the target.


If i am wrong let me knw.. Thank you

Answer / madhavan eyunni

Hello boss, did you tried ?

Let's try, then give me exact ans... ok

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

what is informatica metadata?

0 Answers  

What is batch and describe about types of batches?

2 Answers  

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 mapping performence?

2 Answers   Cap Gemini,

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

major difference between normal loading and bulk loading?

6 Answers  

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

What is decode in static cache?

0 Answers  

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

What is informatica metadata and where is it stored?

0 Answers  

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,