-
-
-
-
-
-
-
-
-
-
What is difference between maplet and reusable transformation?
Maplet consists of set of transformations that is reusable.A reusable transformation is a single transformation that can be reusable. If u create a variables or parameters in maplet that can not be used in another maping or maplet.Unlike the variables that r created in a reusable transformation can be usefull in any other maping or maplet. We can not include source definitions in reusable transformations.But...
-
-
-
-
-
-
-
-
-
ORA-14050: invalid ALTER INDEX MODIFY PARTITION option error in Informatica
I am getting this error "ORA-14050: invalid ALTER INDEX MODIFY PARTITION option" while running a procedure through informatica session. But the same procedure is executed successfully and doing the expected ,while executing in PL/SQL. The output of this proc comes like this ALTER INDEX MODIFY PARTITION < PARTITION_NAME> UNUSABLEIs there any specific syntax for executing alter index option through...
-
Can we use LEFT OUTER JOIN in SQL query override with SAMPLE key word?
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)
Informatica Interview Questions
Ans