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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are active and passive transformations?

1079


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

1187


Target increases every day even though no new record was inserted

1569


What is informatica etl tool?

996


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2849


Explain incremental aggregation in informatica

1115


What do think which one is the better joiner or look up?

1199


What is primary and backup node?

1123


my source is junk data how will u remove that junk data by using unix please any one replay me

3696


How to create or import flat file definition in to the warehouse designer?

1067


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1784


Can you use flat files in Mapplets.

2648


What is fact table? Explain the different kinds of facts.

1072


Define enterprise data warehousing?

1195


How can we use batches?

1020