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
Design a mapping to load a target table with the following values from the above source?
What are the restrictions of union transformation?
What is informatica? Why do we need it?
Mention some types of transformation?
What does refresh system mean, and what are its distinctive choice?
what is the -ve test case in your project.
Separate from a database, an information bazaar, and an information stockroom?
How to open an older version of an object in the workspace?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
can u any challenge your project?
Is there any target staging area in informatica not staging area
What is meant by a domain?
How can repository reports be accessed without sql or other transformations?
Differentiate between router and filter transformation?
What is a sequence generator transformation?