What did you do in source pre load stored procedure
Answer / isha
In stored procedure transformation,
We have option to select source procedure types. Pre-load means - RUN the PROCEDURE before SQ executes the data.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you manage the Parameter files while migrating your data from one environment to another environment?
wht target override?wht advantages it has compare to target update?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
in what type of scenario bulk loading and normal loading we use?
why we r using presql&postsql in source qualifier?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
What is the advantage of informatica?
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)
Explain the mapping variable usage example in informatica
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
if i am having 10 records in source, i want 20 records in target...how will you do it