Interested to Buy Any Domain ? << Click Here >> for more details...
Why we use stored procedure transformation?
- 4 Answers
- 11731 Views
- I also Faced
- E-Mail Answers
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 |
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
i have two source data there is no pk,fk how to join the two sources
1 lac of flat fles in source how to load target at a time?
Scheduling properties,whats the default (sequential)
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
what is the -ve test case in your project.
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
What are the types of caches in lookup?
How can we create index after completion of load process?
suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
Teradata 
