Why we use stored procedure transformation?
Answers were Sorted based on User's Feedback
Answer / anilchandu
Instead of writing complex logics in expression t/r we will
use Stored procedure t/r.
The main advantage of stored procedure t/r is the code
reusability.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rajbir
We use stored procedure transformation top evalate the
expression for rows at database level so that we can use it
again n again according to our requirment
Is This Answer Correct ? | 0 Yes | 0 No |
What r the type of indexes u generally used in informatica?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
how to load rows into fact table in data warehouse
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
How to load last 10 records of flat file in to the target?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
What are the new features in Informatica 5.0?
in which situations do u go for sequence generator ?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.