Latest Answer: Its always preferable & appropriate that we must use a sort stage beore aggregate stage. Hence based on the aggregate logic we should sort the incoming data by using hash partintion on keys. Then we can use same partition on Aggregate stage.This ...
Aggregators – What does the warning “Hash table has grown to ‘xyz’ ….” mean?
Latest Answer: Once we have loaded our dimensions, then as per business requirements we identify the facts(columns or measures on which business is measured) and then load into fact tables.. ...
Latest Answer: Both stages use for joining the data. using merger you can capture rejected data from N no of update datasets but you can't capture master source data. but using lookup you can capture 1 reject data set from source only not from the refrence datasets.Regards,Veeru. ...
What is the diffrence between IBM Web Sphere DataStage 7.5 (Enterprise Edition ) & Standard Ascential DataStage 7.5 Version ?
Latest Answer: dsjob -run -jobstatus projectname jobname ...
Suppose you have table "sample" & three columns in that tablesample:Cola Colb Colc1 10 1002 20 2003 30 300Assume: cola is primary keyHow will you fetch the record with maximum cola value using data stage tool into the target system
Latest Answer: Yes you can query a hash file using Datastage Administrator --> Command window --> ...
Latest Answer: It is used to identify the parameter. ...
View page << Previous 7 8 9 10 [11] 12 13 14 15 16 Next >>

Go Top