DSXchange

aschand,

You mean that is condition 1 and after checking this we should extract records with the below constraint:

can you paste the log here..So that we can discuss what is causing this difference.

kollurianu,

First please search the form before posting. In this way we can have new kind of issues instead of having the older ones.
Actually, this issue was repeated lot number of times.

kollurianu, Seems you have your PWD environment incorrectly configured. First check if you have your User defined environment variable PWD defined or not? Login to Administrator and hit the 'Environment' tab. Then, check on the 'Used Defined' variable. It should have complete project path value in i...

kollurianu,

How is the Nullability of 'WLESSINTCON_INDX' from the source and target defined?
If it is Nullable from the source and you if you are explicitly making it to NotNullable, they you should be doing the Null check.
If IsNotNull(WLESSINTCON_INDX) then WLESSINTCON_INDX else ''

If you are pulling the field from the database, just use Trunc(Field) which gives you only the date. Pull that through the transformer without doing anything. Or as Maveric said, Read the data as varchar and check if the length is more than 10. If it is more than 10, Left(Field,10) If you want to co...

How about converting all the fields of target sequential stage data types to Char.

Sud,

Original poster wanted his target datatype to be of Date datatype. And i guess, we cannot load a value of 'date' datatype without a day in it.

Thanks Ray!!
This post for really informative. :D
Dsuser,
Time to mark it as Resolved if you are allset.

Ray, So, below code along with the date format masking, we will be getting all '01' for days right? StringToDate(InLink.Eff_Year : "-" : InLink.Eff_Month : "-01") How about the below code.I guess we will be getting only the month/year. MonthFromDate(StringToDate(InLink.Eff_Year :...

He was talking about the 'Server side tracing' enabling on the Datastage administrator.
I guess there is no option to do it at the job/sequencer level.

ArndW,

He don't have the day from the source. He just has month and year. Then how can he concatenate and use StringToDate() function without a day?

gnreddy,

What if you want ONLY the rejected records(unmatched) records from the lookup stage and the matched records are not be be captured anywhere?
[/code]

gnreddy,

What if you want ONLY the rejected records(unmatched) records from the lookup stage and the matched records are not be be captured anywhere?
[/code]

Choose one from the below options to read your XML stuff.
1. Sequential stage
2. External source stage