DSXchange

Running the sequence with entering the loop and more than 2 iterations, the sequence is finishing with status "Ok", but i get an information: "Sequencer final was entered, but never exited". This means, the last Job "JobFinal" will not be executed! I am faced with the ...

You need 2 full outer join, 1 for tables and 1 for columns. +---------+ +------------+ => TB_in1_notin2 => peek oder sequential file +DB-Stage + => + + => TB_in1_notin2 => peek oder sequential file +---------+ +Transformer1+ + + => TB_in_both_CREATOR1 => +---------------+ +------------+ => COL_in1_...

I develope with Cognos 7.3 (series 7) and Cognos BI 8 but we don't use (not yet) metastage. For Cognos we use DB2 MQT.

... ETL ends at loading the data into a database called as data warehouse. But what's the use of data when it cannot be converted as information! DW includes ETL plus reporting for analysis (in most cases). People usually go for OLAP tools like Cognos, Business Objects for reporting purpose. In oth...