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 |
can anyone explain me about sales project in informatica?
Tell me about Propagate functions in informatica
Performance tuning( what you did in performance tuning)
Difference Between ETL & ELT?
What are the scheduling options to run a sesion?
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
Design a mapping to load the cumulative sum of salaries of employees into target table?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
write a query to get maximum salary from the employers table without duplicates....kindly help me
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?