Interested to Buy Any Domain ? << Click Here >> for more details...
How to call stored Procedure from Workflow monitor in
Informatica 7.1 version?
- 1 Answers
- 19815 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
what is confirmed fact?
What is surrogate key?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
How to delete duplicate records in a flat file source?
where to select code page option?
when will we go for unconnected lookup transformation in Informatica?
What are the types of maping in Getting Started Wizard?
how to convert the .doc docs into .txt format using informatica
What is rank transformation?
Teradata 
