Latest Answer: Stop on errors=1 (if you set this option to 1 the session will be stopped after occurance of 1 error row. if it is 0 the session will not be stopped even u got n number of errors. ...
Latest Answer: Push strategies: - ETL waiting notification for data would be processed. If the notification contain no data to be processed, ETL must retrieve itself to the source. - Used in realtime ETLPull strategies: - ETL ...
Latest Answer: By enablign sorted input property in Aggregator Properties ...
Can anyone please explain why and where do we exactly use the lookup tranformations.thanks in advacnethanksnayana
In real time scenario where update strategy transformation is used?if we dml operations in session properties then what is the use of update strategy transforamtion ?
Lets suppose we have some 10,000 odd records in source system and when load them into target how do we ensure that all 10,000 records that are loaded to target doesn't contain any garbage values. How do we test it. We can't check every record as number of records are huge.
Latest Answer: Majority of the times the DataWareHouse core tables are in a 3NF form and this is where your entity relationship comes into picture.Further you can have fact and dimension tables which are populated using the core tables. The fact and dimension tables ...
Latest Answer: Additve: A masure can participate arithmatic calulatons using all or any demensions.Ex: Sales profitSemi additive: A masure can participate arithmatic calulatons using some demensions.Ex: Sales amountNon Additve:A masure can't participate arithmatic ...
Latest Answer: Unconected lookups are used in cases where it is not necessary for all the rows to pass through it i.e. for each i/p row query need not be done. ...
Latest Answer: If u r taking connected we return the more than one port, in this we can use the static and dynamic cache and it will support the user defined values.If u r taking unconnected we return the only one port it will support only oracle with this we can use ...
View page << Previous 1 2 [3] 4 5 6 7 Next >>
Go Top
