DSXchange

Attempt inserting without the column

Assume that quotes around null and orch.id is for display only.

You can connect to esxha553 but not esxha554

Because DS is running in 553 but is not running in 554.

Trim happens after right. So there can be extra spaces.

i.e. input is 7 chars length and output takes right 3.

Then why not control in the source itself ? Is it out of reach?

What is achieved by this extraction? i.e. what happens after this extraction?

1.) Do it via the sequencer
2.) Write in a common file and move to the name in after-job activity

1.) Do it via the sequencer
2.) Write in a common file and move to the name in after-job activity

I meant date in the data obtained so that you can constraint the extraction.

You must use that date and check whether it is between your extraction date range.

I meant date in the data obtained so that you can constraint the extraction.

You must use that date and check whether it is between your extraction date range.

Order in director and move in mgr.

If there is no transformation, you can use schema files. But your requirement appears quite vague.

Why use datastage to just pick a few columns? I cannot see any step before or after this activity.

Or build an operator

What 3rd party plugin do you use?

Is there any date like last modified or updated (timestamp) ?

Why don't you write into an hash file and read from it.

Excel s/w has the constraint of 65k rows. Not csv files.

As long as there is no performance problem, one download for full period must work fine.

What about any other columns in the data?

How do you define duplicate in you data?