When we are using Dynamic Cache,which options we will select
in session level?
Answer / ankit
You need to select "Dynamic lookup cache" property in session and also select either "Inser else update" or "update else insert".
Thanks,
Ankit
Is This Answer Correct ? | 1 Yes | 0 No |
What are the join types in joiner transformation?
How to delete the (flat file) data in the target table after loaded.
Is there any target staging area in informatica not staging area
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
What is a difference between complete, stop and abort?
What is data movement mode in Informatica and difference between them?
What is a repository? And how to add it in an informatica client?
what is sql override?what is the use of it?
Diff b/w ShortCut and reusabel Object ?
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,