In Lookup transformation a sql override should be done and disable the cache h

In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?

Question Posted / imran

1 Answers
7961 Views
Wipro, I also Faced
E-Mail Answers

In Lookup transformation a sql override should be done and disable the cache how do you do this pr..

The interviewer just check your knowledge about Informatica
Lookup Transformation.

If you disable cache you can't override the default sql query.

Follow Informatica Help.

Regards
Sukanta

Is This Answer Correct ?

9 Yes

1 No

Post New Answer

More Informatica Interview Questions

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers Patni, Wipro,

what is a time dimension? give an example?

2 Answers IBM,

How can we remove the duplicates from flat file source?

0 Answers

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers Cap Gemini,

What is the function of aggregator transformation?

0 Answers

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,

0 Answers HCL,

what r the transformations that r not involved in mapplet?

8 Answers Wipro,

What is different between the data warehouse and data mart?

0 Answers

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers

what is scd?

6 Answers

Explain about HLD and LLD ?

16 Answers Accenture,

Explain factlessfact table with scenario

1 Answers HCL,

For more Informatica Interview Questions Click Here