How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
Answer / kalyan
If the stored procedure id used to do any operations on the
database tables (say Dropping the indexes on the tgt table
or renaming it or truncating it)then call them at the Pre
SQL and Post SQL options at the session properties of the
Target.
Is This Answer Correct ? | 12 Yes | 5 No |
How union transformation is active ?
What is the Process to creating lookup transformation in informatica
Explain about Informatica server process that how it works relates to mapping variables?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
why we use informatica in our project?
What are the types of lookup transformation?
How to generate a single mapping for both the historical and incremental load.
What is confirmed dimension and fact?
What are the guidelines to be followed while using union transformation?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What you know about transaction control transformation?