DSXchange

If your table is empty then Yes, no records will pass through. You need to incorporate the IsNull() check within the database stage. And send a single row.

Ray might have nailed it, yet again. You need to tell us what command are you using to run your job and where are you seeing this status code?

Welcome Aboard
Use the serch facility of this website. It is very powerful and will save you a lot of time. Do an exact search on "Error finalizing". You will see that such an issue has been covered before.

Change Capture Stage will capture changes as codes in an additional column. This extra column will have codes. Read about it in DS help.

Read about the codes in Parallel Developer's Guide. Its all there in the Change Capture chapter.

Good to know. Make sure you add more comments to the routine if required. C is such a language that a few days down the road you wont know what the code is doing.
You can mark the post as Resolved now.

I guess I take my statment back. Any Red color in the transformer would force me to go for alternatives and hence I never played with it and hence my ignorance.

Go for len(trim(in.Col)) - 1. But ArndW has a very valid point. No string manipulation is required.

Thats it. Is it that simple Well, this way, MERGE can also be used for Inserts right

I know this is off topic but Ken, someday you have to tell us how to do the co-related updates aka bulk updates.
Thanks,

ArndW wrote:There is no need to do any string manipulation or conversion if the datatype is specified correctly in the first place.

Point duely noted

You can do something like

How are you loading your fact table now. Are you collecting all your data into a flat file in one job after all the lookups and transformations and then in a second job loading into your table or everything in one job without an intermediate sequential file stage?

Is (-) the only trailing character you are getting or there are others? Is this a packed field? What does the trailing (-) represent?

dsjob -report will get you all that information along with the job status. You can parse it and bring it in a whatever format you like.