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

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

What does reusable transformation mean?

0 Answers  

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

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

4 Answers  

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

What is a sorter transformation?

0 Answers   Informatica,

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,

what is confirmed dimension?

6 Answers