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

When will you use SQL override in a lookup transformation?

1 Answers  

What is incremental aggregation?

0 Answers  

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

What are the different types of olap? Give an example?

0 Answers  

what is the dashbords?

1 Answers   IBM,

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

without table how to come first record only in oracle?

0 Answers  

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories