If you want to create indexes after the load process which
transformation you choose?
- 3 Answers
- 19475 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are mapplets?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is exclusive and normal mode for repository services?
Differentiate between a database and data warehouse?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is session task and command task?
Explain the informatica workflow?
Differentiate between reusable transformation and mapplet.
What is the difference between source qualifier transformations source filter to filter transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the measure objects?
While migrating the data from one environment to another environment how would you manage the connections?
What is the difference between informatics 7x and 8x and what is latest version?
Differences between version 7.x and 8.x.
What is different between the data warehouse and data mart?
