Interested to Buy Any Domain ? << Click Here >> for more details...
In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
- 2 Answers
- 8609 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 |
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
How to display null values on a target & non-null values on a target?
How do you take back up of repository?
Why we use partitioning the session in informatica?
Why should we use star schema in datawarehouse design?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
what is row level and column level indicator?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
Teradata 
