In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
- 2 Answers
- 8009 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 |
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
What are the differences between oltp and olap?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
HOW TO DELETE A RECORD FROM FLAT FILE
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
can we have to do changes in session property when we are dynamically generating target files?
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
What are the associated ports in look up T/R.
Teradata 
