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

2 Answers
8749 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / janardhanreddy yerraballi

Below error will be thrown ed.

"TRANSF_1_1_1> CMN_1021 Database driver event...

CMN_1021 [

ORA-00933: SQL command not properly ended

Database driver error...

Function Name : Execute

SQL Stmt : SELECT --

Is This Answer Correct ?

0 Yes

0 No

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

Answer / bprathap4u

Session will be failed with following error message

Message Code: CMN_1254
Message: ERROR: Feature not yet supported: [Lookup override
with caching off]

Is This Answer Correct ?

1 Yes

4 No

Post New Answer

More Informatica Interview Questions

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers IBM, ITC Infotech,

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers CTS,

How to convert flat file into xml file? How to tune joiner?

2 Answers Accenture,

explain about informatica server architecture?

1 Answers IBM,

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers TCS, Wipro,

What is an incremental loading? in which situations we will use incremental loading

2 Answers HCL,

What is the difference between a repository server and a powerhouse?

0 Answers

can anyone explain me about sales project in informatica?

8 Answers MBT, Satyam,

In joiner, how to load Master table in Target?

2 Answers

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers

What are connected or unconnected transformations?

0 Answers Informatica,

Diffrence between 7.1,8.1 and 8.6

3 Answers HCL, Wipro,

For more Informatica Interview Questions Click Here