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 the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Make a note of the quantity vaults made in informatica?
How to use procedural logic inside infromatica?
How can you increase the performance in joiner transformation?
define galaxy repository in informatica
What is complex mapping?
How many input parameters can exist in an unconnected lookup?
r u done any partitions in ur project?
differences between service based and product based?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Explain pmcmd command usage in informatica
What does command task mean?
Where is metadata stored?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?