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

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

What are the different types of Type2 dimension maping?

1 Answers  

From where we can start or use pmcmd?

3 Answers  

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

version controlling in informatica?

3 Answers  

can we create index and drop index in exsisting table while using infomatica

4 Answers  

What is a test load?

1 Answers  

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,