problem with funnel

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsxdev
Participant
Posts: 92
Joined: Mon Sep 20, 2004 8:37 am

problem with funnel

Post by dsxdev »

Hi
I three Datasets from which I am reading data , Dataset A, Dataset B and Dataset C.
I am generating a Dummy Column.
These three datasets have output to three Column Generators which generate the Dummy column value as 1, 2 and 3 for rows coming from Datasets A,B and C respectively.
Records from these three datasets are input to a Funnel.

Data from the Datasets is coming fine and output of each column generator is fine but when the data comes out of the Funnel Stage some columns coming from the third Dataset C are becoming Null in Char columns and 0 for Integer columns.
All these columns are nullable.

Can any body tell me what could be the reason?

These columns were added to the Datasets recently prior to adding these columns the job worked fine. These columns were added to all the three Datasets.

Any input would be helpful.

Regards
Happy DataStaging
itsme_rp
Participant
Posts: 5
Joined: Thu Oct 28, 2004 2:29 am

Post by itsme_rp »

Hi Please check the metadata of all stages source,funnel and target. All should be same else it may generate Null values..
mandyli
Premium Member
Premium Member
Posts: 898
Joined: Wed May 26, 2004 10:45 pm
Location: Chicago

Post by mandyli »

after adding new column you need import latest metadata. before import check in the Database whether new column null or not null.


Thanks
man
Post Reply