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 is the use of source qualifier?
r u done any partitions in ur project?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How can we remove the duplicates from flat file source?
What is the difference between informatics 7x and 8x and what is latest version?
What is the function of union transformation?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How we can create indexes after completing the load process?
What do think which one is the better joiner or look up?
In development project what is the process to follow for an etl developer from day1
Explain constraint based loading in informatica
What is meant by active and passive transformation?
without table how to come first record only in oracle?
What are the types of data warehouses?
How to do unit testing in informatica?