a2zinterviews

76.	What is difference between aggregator and expression?
	Aggregator transformation used to perform aggregate calculation on group of records Where as expression used perform calculation with single record.
	Discuss Ravi Ranjan ,says Feb 10,2018 Aggregator is active transformation. Aggregator transformation is use grop by basis. it is use muli function of Oracle such As SUM, AVG, First_Name, Last_Name while Expression transformation is passive transformation Expression tranformation use row by row Expression transformation is use single function of Oracle. E.x. Full Name Concate- IIF(First_Name || ' '|| Last_Name). Your Name Your Email-ID Your Answer

77.	What is the default source option for update strategy transformation?
	Data driven.
	Discuss Ravi,says Feb 11,2018 Update strategy transformation having All Properties in Data driven Data driven e.g insert Delete update Reject. Your Name Your Email-ID Your Answer

78.	What is the difference between sequential batch and concurrent batch?
	In sequential batch one session will end then the other will begin. Where as in the concurrent. Batch the sessions will run simultaneously depending on the CPU availability.
	Discuss Ravi ,says Feb 07,2018 Sequential batch having one Session Like as per expression transformation using this as one row V_count = V_count_1 second row O_count = V_count First row we will excution my session , we got Output 0 + 1 =1 1 + 1 =2 So Second row will get out as 1,2. Your Name Your Email-ID Your Answer

79.	What are the types of tracing level?
	Normal Verbose Verbose init Verbose data
	Discuss Your Name Your Email-ID Your Answer

80.	What is update strategy transformation?
	This transformation is used to maintain the history data or just most recent changes in to target table.
	Discuss Ravi ,says Feb 07,2018 Update strategy transformation is Active Transformation. in any Scenrio we got not value data , i explain briefly such as If One Record Delhi is Present in Database While we updated Delhi in Londan,Puna Etc So we go for updated strategy transformation so updated strategy having following properties 1 insert 2 Update 3 Delete 4 Reject. Your Name Your Email-ID Your Answer