In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
- 2 Answers
- 8077 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 |
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
What is Datadriven?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
What is partioning?how many types of partinings are there
hi all, Can anyone please tell me the relationship between informatica and business objects
Why we require dwh in particular projects?
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
What is Performance tuning in Informatica?
Why filter transformation is an active one?
In Which scenario did u used Incremental loading?
Teradata 
