DSXchange

Man, How soon the job1 completed & how long you waited for Job2 to see that it is not reading any records? Both should run fine. Let Job2 to run for sometime and see if at all it processed some records.

I guess it's more of a display issue..

Do you get this error when you rerun the job?

The only difference is that if you mess it up, someone might die.That's it. That was a good one :) OP, For me, it really does not matter for an ETL consultant or developer working across industries/domains. Terms will be new for you initially, but processes will be the same. You will become familia...

When is that guy coming back? Will he?

I don't know what else i can do... Wait for someone who can paste a screen shot here.. Will that happen ever?

Meanwhile, Why don't you read DS documentation to get this resolved?

Oops.. That's what i explained in my previous replies.

Yes Eric

What Eris said is correct. You should stick to that 38,10 in OCI and do the length change in downstream transformer. ** No need for an explicit conversion in this case.

Basu, did you ever create a message handler in source environment? If yes, when you open message handler manager from designer, you will see a drop down list which lists out all available message handlers. If you don't any see in the drop down list, that means you don't have a message handler for th...

I posted a detailed reply and i could not see it here. God.. should i type it again? Let me make it simple.. Source Env -> DataStage Designer/Director -> Message Handler Manager/Management -> copy -> {paste in Message Handler Manager/Management of target environment} -> save it ;) -> close it.

It's going to be a public holiday tomorrow... but some questions like this make me think like going home instead of fun filled places

User defined SQL in respective DB stage!!

Deepa... Here is something you can try but one additional requirement is highlighted in bold This is purely from thought process and never been tested. Sample Input: 1,ID,13 1,Name,xx 1,Place,yy S,SSSS,SS --> (Add this dummy row to your input file as last row) Requisites: Ensure that the records wit...

That's a nice requirement Deepa