DSXchange

Not sure what you want to achieve. Can you please rephrase your requirement.
gives you number of characters and not words. So it gives you 2 - 1 for zero and 1 for newline. If you want words, try , which will give you 1.

Rather than using one parameter within another, you can concatenate both in the query as

Select ...
From ....
Where fieldname = '#parameter1# #parmaeter2#'

You can do

Hash file appears to be constrained to 'update only' mode with the key missing.

Is that expected as part of your design ? Maybe it is out of sync.

Is this a QualityStage question ?

Because qualitystage has different reference files which are used for tokens.

Are you sure you are not appending to the export file ?

Hashed files are keyed by id and cannot return multiple rows.

All rows from your input will be passed to your reference unless you mention any constraint on the flow.

Sunitha_cts, Can you please avoid posting your interview questions and expecting answers on this forum as it undermines the experience and knowledge people gained from hours of hard work. Personally I have seen people who promise too much in the interview, chat up for some time after joining but the...

Can you rephrase the question.

Are you asking the count of DLLs in the pack?

Lookout for any quote or special characters which may interrupt the string.

Did you check the datatype, length etc of the joining columns ?

Is it a case sensitive match ?

What do the records which do not join have in common? Try to locate the keys of missing records in the counterpart source manually.

Run the target in sequential mode.

sezerman wrote: it works when 2 or 5 records but the third job has 16000 records and it doesn't work.

Define " doesn't work ".

It may be useful to press ellipse (....) against the parameter name and select from there.

chulett wrote:

Sainath.Srinivasan wrote:Also did you bounce your datastage instance after changes to dsenv ?

FYI - unnecessary.

I have found this necessary to load dsenv parameters part of datastage environment.

Some instances are when you hit library problems.