If you want to create indexes after the load process which
transformation you choose?
Answer Posted / prasad
unconnected stored procedure with the property called target
post load
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
Define update strategy?
What are the differences between source qualifier and joiner transformation?
How to create or import flat file definition in to the warehouse designer?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is target load order?
How to join three sources using joiner? Explain though mapping flow.
How to partition the Session?
Global and Local shortcuts. Advantages.
What is the difference between STOP and ABORT options in Workflow Monitor?
What is source qualifier transformation in informatica?
What is the use of transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How can you validate all mappings in the repository simultaneously?