Class12 - Informatica Powercenter ETL скачать в хорошем качестве

Class12 - Informatica Powercenter ETL

TOPIC'S DISCUSSED UPDATE STRATEGY TRANSFORMATION 1. ACTIVE TRANSFORMATION AND CONNECTED 2. USED TO PERFORM 4 ACTIONS A. INSERT 0 DD_INSERT B. UPDATE 1 DD_UPDATE C. DELETE 2 DD_DELETE D. REJECT 3 DD_REJECT 3. TREAT SOURCE ROWS AS(OPTION IN SESSION PROPERTIES) - WILL BE AUTOMATICALLY SET TO DATA DRIVEN WHEN EVER OUR MAPPING CONTAINS UPDATE STRATEGY TRANSFORMATION INTEGRATION SERVICE WILL BE PERFORMING THE ACTION OR OPERARTIONS BASED UPON THE PROPERTY THAT WE SEPCIFY IN UPDATE STRATEGY TRANSFORMATION IN MAPPING NOTE: IQ'S WITH OUT USING UPDATE STRATEGY TRANSFORMATION, CAN WE PERFORM INSERT,UPDATE AND DELETE YES , ON THE SESSION PROPERTIES WE NEED TO SET TREAT SOURCE ROWS OPTION TO INSERT,UPDATE,DELETE ACCORDING TO OUR REQUIRMENT. WE ALSO NEED TO SET SOME TARGET OBJECT PROPERTIES ACCORDING TO OUR NEEDS INSERT UPDATE DELETE UPDATE ELSE INSERT