to make the Transformer Wait for the file
Posted: Thu Dec 14, 2006 3:08 pm
Well i have this job where in i need to make the transformer wait for the file that is written in the same same job .
the req i have is that i need the count of the records getting into the output file and at the same time i need to extract the input record count from the input file and load both of these info into a single Oracle table .all these are done from the transfprmer stage.
the problem i'm facing is that the transformer is extraxting the input record count real quick ie much bofore all the records are loaded into the output file . so i'm not getting the right output count as the transformer loads the input count and the output count as per the number of records passed at that instant ,into the oracle table the moment it completes getting the input count .
Can somebody help me with this issue ?
Thanks
Shalini
the req i have is that i need the count of the records getting into the output file and at the same time i need to extract the input record count from the input file and load both of these info into a single Oracle table .all these are done from the transfprmer stage.
the problem i'm facing is that the transformer is extraxting the input record count real quick ie much bofore all the records are loaded into the output file . so i'm not getting the right output count as the transformer loads the input count and the output count as per the number of records passed at that instant ,into the oracle table the moment it completes getting the input count .
Can somebody help me with this issue ?
Thanks
Shalini