Dataset does not shows the columns
Posted: Tue Sep 30, 2008 1:04 am
Hi All,
The job design is as follows
dataset
|
|
|
dataset------->lookup------>dataset(target)
(I dont know to put the diagram exactly, dataset is looked up with another dataset)
In the column definition on the target dataset there is a column named "AR_PRIM_PYMT_TP_DT".The rows ran fine.But when i tried to view the dataset it shows
" Error executing View Data command:
##E TOPK 000000 12:25:57(027) <_PEEK_IDENT_> Input dataset does not have field: "AR_PRIM_PYMT_TP_DT"....."
I tried to look the columns in dataset management but the column"AR_PRIM_PYMT_TP_DT" is not there.
I tried by checking "Runtime column propagation" in the administrator,but in vain. Please help me to resolve the problem
The job design is as follows
dataset
|
|
|
dataset------->lookup------>dataset(target)
(I dont know to put the diagram exactly, dataset is looked up with another dataset)
In the column definition on the target dataset there is a column named "AR_PRIM_PYMT_TP_DT".The rows ran fine.But when i tried to view the dataset it shows
" Error executing View Data command:
##E TOPK 000000 12:25:57(027) <_PEEK_IDENT_> Input dataset does not have field: "AR_PRIM_PYMT_TP_DT"....."
I tried to look the columns in dataset management but the column"AR_PRIM_PYMT_TP_DT" is not there.
I tried by checking "Runtime column propagation" in the administrator,but in vain. Please help me to resolve the problem