DSXchange

Hi All, I was going through the SCD related posts to understand how it works. I got few links and tutorials also, but I can't see all the tabs what is told / shown in these. E.g. In input tab I can't see any tab like lookup, surrogate key; just have regular tabs like General, Columns, Advanced, Part...

Thanks chulett ! It has solved the problem.

Hi All, I have created a simple job to extract data from xml file and loaded it into sequential file. For e.g, if source is as below, <Customer> <FName> Titi </FName> <LName> Maiti </LName> <FName> Arup </FName> <LName> Roy </LName> </Customer> Then output should be as, Titi,Maiti Arup,Roy But the j...

But Our requirement is:

1. First Load data in to a sequential file with delimiter '||'.
2. After that other team will be using that sequential file to load into a target table.

If we do this in the transformer stage then is it possible to do the above stages.

Can some help me on this.

Hi,
Is it possible to add more than one delimiter in a target sequential file in Server job?

Hi All, We are currently working on a Customer MDM solution with Quality stage. Jobs are developed with Standardization, Match Specification stages. Now need to tune it to improve the performance / space requirement. Also need to estimate QS memory requirement for volume like, History load : 150 M (...

Hi All, Thanks for these unix tips ! But in our project we have NLS installed, so would like to do this conversion (Latin 1 to UTF-8) through Data Stage V 8.0. We have set the job level NLS map to ISO-8859-1 and able to read Latin 1 chars properly. Job looks like: Source Seq file - > Transformer - >...

Hi All, We are migrating jobs to QA env from Dev env, QA env is newly set up and may not have all the required features. We are able to run parallel jobs without any target reject link in QA, but after adding the reject link (from target ODBC stage) it's failing with below error message, Error when ...

Thanks ArndW!

We have verified that C++ is not installed. I understand that Transformer stage needs this. But can't we compile job sequences also without C++ installation ?

Hi All, We are migrating the Jobs from one environment to another environment but we are not able to compile the jobs having transformers (though jobs without transformer are getting compiled properly in new environment.) The error is coming as below, ##I IIS-DSEE-TBLD-00079 05:58:50(073) <transform...

Yes, we have tried diff, but it's not showing any difference other than 2 rejected records. This rejection is due to business logic, which is fine.

Can anyone give any suggestion ?

Thanks,
Ankita

Hi All, We are using Quality Stage to do Email validation. There is one rule as, - If an Email comes as xyz@yesmailcom then change it to xyz@yesmail.com or if input is abc@sbicoin then it should be abc@sbi.co.in i.e. if . is missing then that should be incorporated.A set of valid domain names are av...

In our project, APT_CONFIG_FILE is set to config files and was working properly till date. Suddenly started throwing this error, we found that DS server is up, and config files are existing is proper path, but /tmp dir is 100% full, no space left. Can it be a space issue ? Thanks for your responses !

Hi,

While compiling a job with parallel transformer we are getting below error:
"A configuration file (APT_CONFIG_FILE) must be set up to compile a Parallel Transformer stage".
Can you please help to solve this problem.

Thanks,
Ankita

ArndW, Thanks for your suggestion ! I just tried with upsert (with same set of input) , but failing with similar problem.