1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

When we are using Dynamic Cache,which options we will select
in session level?

Question Posted / brahmaiah.dwh


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

Post New Answer

More Informatica Interview Questions

What aer the out put files that the informatica server creates during the session running?

4 Answers  

what is work of PUSH DOWN option

2 Answers   Wipro,

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

What is lookup transformation?

0 Answers  

What is Java Transformation? what are the uses of it?

0 Answers   TCS,




source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

what is polling?

1 Answers   Informatica,

What is the different lookup cache(s)?

0 Answers  

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

For more Informatica Interview Questions Click Here
Categories