In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
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 |
What does “tail –f” command do and what is its use as an Informatica admin.
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
What is the need of etl tools?
In real time scenario where can we use mapping parameters and variables?
Can we run session without using workflows?
what is the necessity to use update strategy?(except for updates)
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
How can you change from reusable session into non-reusable session.
my source is junk data how will u remove that junk data by using unix please any one replay me
What is update strategy transform?
What is informatica? Why do we need it?
Differences between connected and unconnected lookup?