Could any one please tell me how informatica behaves in the following situation?(Let me explain you with example: I have following expression in a mapping I would display either FAIL or PASS status to a record.RESULT=IIF((A > (100 - B))OR(C > (100 - D))OR(E0) , 'FAIL', IIF(STATUS_I = 'FAIL', 'FAIL', 'PASS'))Where the following variables are decimalsA (Decimal(9,2)) = 2.0179896789716073791692725900792e-5B(Decimal(9,2)) = 99C(Decimal(9,2)) = 50D(Decimal(9,2))=
Latest Answer: Using UPDATE STRATERGY, we can update the target tbale based on ket columns. To update the target table based on non-key columns, we can use the update override option in the target. ...
Latest Answer: We can get multiple values from unconnected lookup return port using conncatination logic, then we have to split the values to respect columns Do you need more information call 9833705604venu adavelly ...
Latest Answer: It is a intersection table between a dimension table & fact table with a multipart key capturing a many-to-many relationship ...
Latest Answer: Cache look-up uses either Static or Dynamic cachesUnchached look-up uses static caches. ...
We are planning to move from Informatica 6.1 to 8.1. I need to know the steps/guide for upgrading the repository.It is possible to go from version 6 to version 8 directly or we have to move to version
Latest Answer: Hi Ahmed,Did you ever get the steps how to upgrade from 6.x to 8.x. If Yes please can you send it over to me, it will be of great help to me. U might receive my email but its ansaar02@yahoo.com or arshads_02@yahoo.com.Thanks a lot in Advance.RegardsAnsar. ...
If a record with 40 data type size from oracle& 100 from siebel (source) but target data type size is 50 , then how informatica server handles this situation?
Can we use LEFT OUTER JOIN (ANSI SQL standard) in SQ query override with SAMPLE key word?(help me my dba used same in a mapping which have 5 rel SRCS from a single db and contain expression -- directed to TGT)
View page << Previous 9 10 11 12 [13] 14 15 16 17 18 Next >>
Go Top
