DSXchange

If we check only the 'Clear File before writing' and uncheck the 'create file' options on the hash file stage, will these options create a hash file? or is it must that 'create file' option should be checked to create hash? Clearing the file before writing has no bearing on whether it gets created ...

A good idea? Checking for both would make it harder to go wrong.

When I have the condition like Ex: If Not(ResultCol) then 'xxxx' else 'yyy' When we use the Not() with boolean does it mean 'Even the expression is true or false the result should be xxxx'? No, it reverses the evaluation of the condition. So, rather than a TRUE result taking the if clause, ...

Why not simply check the the vendor's website for the product? Drill down from there...

The Devil is in the details, apparently...

naren6876 wrote:Iam not able to send mails to morethan one at a time by using the Notification Activity.
Iam giving the recipients email address like abc@yahoo.com,fds@yahoo.com........ with comma delimiter.

Separate them with a space... however, as noted, using a 'list' or 'group' email address is better.

Wait for it... wait for it... [rises to the bait] - Does that mean you are a half-wit? <rim shot>

Try the veal.

Well then, young Padawan, your job now becomes even tougher. You are going to have to spin up your own code to handle this. A couple of suggestions... There are ways to count substrings in strings that you can find in the Help. You can use one of them to determine how many delimiters you have in you...

DataStage won't automatically sub out the F_NAME for the value you set it to when it's inside quotes - it's just a string. Build your command line from the pieces so it knows: CmdString="cat ":F_NAME:" |wc -l" Call DSExecute("UNIX",CmdString,Output,SystemReturnCode&...

First thing I'd suggest is you check out the Pivot stage, it does almost exactly what you need. Adding the INROWNUM bit to it might be interesting, however... or simple... don't know off the top of my head. Got no time to ponder something like that as I'm heading out the door when I hit Submit. Read...

Not sure what you mean by "require entry in sequence into a target field". Do you need to concatenate them all into one large data element before sending it to the field? Or perhaps you need to turn one record into five, with each entry in your 'source group' creating a new record with a different v...

Exactly. We have a Microsoft Exchange Server and Outlook here at work, so we have multiple Distribution Lists setup for the various ETL 'areas'.

Two choices: 1) Use (or create) an email group for the process rather than individual emails. That way you can add or remove people from the notifications without having to touch the job. My preferred methodology. 2) If you need to, you can put multiple addresses seperated by a space in the Notifica...

Welcome Aboard! :D I think your expression is fine... syntactically, except for the extra equal signs: If x='hyd' then 1234 Else If x='delhi' then 3456 Else If x='Bangalore' then (If (zipcd>2456 and zipcd<2500) Then 8976 else 8977) Else If x='Bombay' then (If (zipcd>2456 and ...

kduke wrote:Did I put you to sleep with my rant?

No, no, not at all... I look forward to the occassional Duke rant. It's just been a loooong (_._) week and I needed to catch up on much lost sleep. I was moments away from going to bed when I (blearily) started to read your post.