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 is normalizer transformation?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
What do you understand by SOA of Informatica?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
what happens when a batch fails?
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
can we see default group,when we use router?if yes how?
Where should yoU place the flat file to import the flat file defintion to the designer?