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
- 8650 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 table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
What you know about transaction control transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
Which one is better performance wise connected/un-connected lkp?why?
What are the types of lookup?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Explain why we use partitioning the session in informatica?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
what is the incremental agrrigation?
What are the unsupported repository objects for a mapplet?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
What are the mapping paramaters and mapping variables?
Teradata 
