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...


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

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 normalizer transformation?

4 Answers   Wipro,


how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,


What do you understand by SOA of Informatica?

0 Answers  


i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,


A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,


Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,


on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,


what happens when a batch fails?

3 Answers  


i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,


Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,


can we see default group,when we use router?if yes how?

2 Answers   L&T,


Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  


Categories