Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

Question Posted / imran

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

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

what is constraint based load order

2 Answers   Cap Gemini,

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

How might you approve all mappings in the archive all the while?

0 Answers  

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,

What are the basic needs to join two sources in a source qualifier?

3 Answers  

How you prepared reports for OLAP?

0 Answers  

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

How the facts will be loaded? explain

2 Answers   HCL,

what is inline view?

1 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories