DSXchange

Pretty much just like that, without the assingments and the semi-colons. The TYPE field should be the target of the derivation and use something like this: IF B_DT >= PCKG_BEGIN_DT AND B_DT <= FMC_PCKG_END_DT THEN 'N' ELSE IF A_END_DT >= PCKG_BEGIN_DT AND A_END_DT <= FMC_PCKG_END_DT THEN 'R' ELSE 'C...

There should have been something specific that came with the PACK itself.

Oh my... a reference to Smeagol when inputs are mentioned as precious.

To quote Scotty: "We're goin' nowhere might fast, Captain".

It might be that your final output is causing issues. Are all 4 tables different ones? Or is the output table the same as one (or more) of the input/reference tables? If so, depending upon your ODBC options, you might be deadlocking yourself. Asked and Answered, your Honor. In the other thread on t...

Operator role can be assigned to the production support people. Ugh... sure, you could - but you'll regret it. It still requires jobs to be released before an 'Operator' can see them so best to not go there. You shouldn't have to do anything special to allow anyone to look at and run jobs in a Prot...

I mean I need to trigger a job from a web page? lets say,server ip/hostname:=a, job name:=x, project:=y How to run this job? Please suggest. As noted, you would need to launch the job using the command line 'dsjob' executable on the DataStage server machine. You have what seems to me three options ...

Kumudhini - welcome. Before anyone can really help you, you need to correct a couple of problems. 1) You need to start a new post in the appropriate Forum. Jumping on to the end of someone else's resolved problem is frowned upon. Biggest reason is we have no idea what your 'particulars' are - job ty...

All stuffs in a go? Batch file, I would guess.

Sounds like you may need to tune your first query. Have you checked the explain plan? Gotten help from your DBA on how you can improve the performance of the query? Or to verify that there are no blocking locks when you get 'no response'?

You need to start here, the eService Information Integration Solutions Portal:

https://www.ascential.com/eservice/public/welcome.do

You'll need an active support contract and a userid for the site. If you have both, then you can download whatever patches are available, including the one I mentioned.

kumar_s wrote:929.907 is just the sum of all FEP from the source table. To find the sum, use Aggregator, and use SO_NUM as key and find the sum of FEP, Max for other attributes.

Or "Last" depending on what 'latest value' means to you.

'Trigger' usually means launch using either 'dsjob' from the command line or your standard wrapper script for dsjob. Have you looked into that?

You don't really have 'three source tables'. You have one source table with two ODBC-based reference lookups. That means that for every record in from the first table, a query is executed against each of the other two tables. As Narasimha notes, if these tables are in the same instance then you shou...

You can't. You can post a picture of the data using Image tags and one of the many free file hosting sites. Or just paste a sample in your post, unless it's large and crazy.

I almost said no, thinking of using them for a source query. For target sql, anything you mark as a Key field is used in the where clause of the Update Action automatically.

You might want to give more details about what it is you are attempting to do so that you can get more specific advice.