In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
- 2 Answers
- 7546 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Session will be failed with following error message
Message Code: CMN_1254
Message: ERROR: Feature not yet supported: [Lookup override
with caching off]
| Is This Answer Correct ? | 1 Yes | 4 No |
 Code page compatibly –Where all changes are made to handle the scenario.
What are the tuning techniques you applied during your last project
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
what is the hint? how to use it to reduce the query processing in program?
What did you do in source pre load stored procedure
What is the use of source qualifier?
What is incremental aggregation?
What is the default join that source qualifier provides?
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
How we can create indexes after completing the load process?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
how to connect two or more table with single source qualifier?
Teradata 
