If you want to create indexes after the load process which
transformation you choose?
Answers were Sorted based on User's Feedback
Answer / bsgsr
stored procedure transformation can be used to create and
drop indexes before and after loading into the target.
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / kalyan
use the post session SQL to craete indexes on the target
table..
Is This Answer Correct ? | 11 Yes | 1 No |
What is operational data source (ODS)?
What is power play plug in?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
What are the types of maping in Getting Started Wizard?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
How do you load first and last records into target table?
difference between informatica 8.1.1 and 8.6
when will we go for unconnected lookup transformation in Informatica?
What are the types of caches in lookup? Explain them.
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
when informatica 8 series released ?