What are the types of data that passes between informatica
server and stored procedure?
Answer / swetha
3 types of data
Input/Out put parameters
Return Values
Status code.
| Is This Answer Correct ? | 4 Yes | 0 No |
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What are the advantages of informatica?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
What is sql query override? When did u use sql query override?
What are Target Options on the Servers?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
What is update strategy transform?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
How can we improve session performance in aggregator transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain the informatica workflow?
i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?