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
What are active and passive transformations?
How to handle decimal places while importing a flatfile into informatica?
Target increases every day even though no new record was inserted
What is informatica etl tool?
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.
Explain incremental aggregation in informatica
What do think which one is the better joiner or look up?
What is primary and backup node?
my source is junk data how will u remove that junk data by using unix please any one replay me
How to create or import flat file definition in to the warehouse designer?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Can you use flat files in Mapplets.
What is fact table? Explain the different kinds of facts.
Define enterprise data warehousing?
How can we use batches?