How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
Answer / kalyan
If the stored procedure id used to do any operations on the
database tables (say Dropping the indexes on the tgt table
or renaming it or truncating it)then call them at the Pre
SQL and Post SQL options at the session properties of the
Target.
Is This Answer Correct ? | 12 Yes | 5 No |
How can you differentiate between powercenter and power map?
All active transformations r passive or not?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
what is the -ve test case in your project.
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
what are challenges that you faced in testing? give solution to it?
how we load the data from source to staging area
Write the prerequisite tasks to achieve the session partition?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How do you use reject loader.
What is the benefit of session partitioning?
What is target designer and target load order?