Develop a mapping to extract the employee drawing maximum salary where deptno = department drawing maximum sum(salary) group by dept.sources are cobol files / flat files.
This is the recent question faced in ibm.
Latest Answer: Update strategy transformation determines whether to insert, update, delete or reject a record for the target. We can bypass update strategy transformation by creating a router to divide rows based on insert, update, etc and connecting ...
How you capture changes in data if the source system does not have option of storing date/time field in source table from where you need to extract the data?
The DW database can be Oracle or Teradata. The requirement here is to pull data from source system and ETL need to device a mechanism to identify the changes or new records. The source system can be a
Latest Answer: The full form of ODS is Operational Data Store.ODS is a layer between the source and target databases..ODS is used to store the recent data.Staging layer is also a layer between the source and target databases..Staging layer is used for cleansing purpose ...
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.
View page << Previous 1 [2] 3 4 5 6 Next >>
Go Top
