DSXchange

When I try to write to a teradata table, an ORCH_HOME table is created every time the job is executed and data is written to the table. Any idea on how to set it as one single table, so that DS can overwrite that table everytime the job is executed, instead of multiple tables getting created? Thanks

This is what we have put in the description of the output tab of XML input Stage.

Output of XML input stage is feeded to lookup stage and from this stage to table. input consists of group of repeting section like this. <a> <b>1</b> <c>2</c> </a> <a> <b>3</b> <c>4</c> </a> And we want each repeating groups to be a row in the output, like 1 2 3 4

We have used XML input stage to read Xml file. Bofore XML input stage we have used external source stage to feed the XML input stage. We have loaded the the XML input stage its meta data, and made a column as 'key' column since I got a warning that a key column should be specified for a repetition e...

Hi, I have the following requirement to be implemented in the job: There are 4 - 5 fields in a file, out of this there are two fields based on which the record can be treated as a duplicate. For example, Scenario 1: F1,F2,F3,F4,F5 100,200,300,Y,- 100,200,300,Y,99 100,200,300,N,81 100,200,300,Y,81. I...

So, You can Resolve the issue. I have a new issue here. Since I gave multiple rows return option in the lookup, for a source record if there are more than one matching record in the lookup, then the output of the lookup is 2 identical rows(all columns from source) except for the other column fetche...

Thanks a lot, I tried the 2 option without sparse lookup and it worked. Hi, 1) your date comparision is incorrect. You are comparing strings here instead of dates. ( I assume that incoming date value is a string ) to_date(ORCHESTRATE.STDATE,'yyyymmdd') between RECEFFDATE AND decode(RECENDDATE,'',sys...

Hi, I have an oracle table with an customer id, customer name, start date,end date. This is a dimension table with SCD-Type2 logic. I have a source txt file which has a date column and the customer id. I need to fetch the customer name from the dimension table(oracle) based on the customer id and th...

I am trying to read from a fixed width file, The file has fixed length record with 500 fields. I am reading only 50 fields out of it by giving the appropriate start positions. The record length is 3300 characters. I'm reading all fields as Char. When i execute the job, it gives me the following warn...

Hi, We have a job which reads a record from a source file(csv), splits that single record into 4 records. These four records are populated to four different fixed width files. Each record has a different metadata. that is the number of columns vary between the 4 records, whereas the record length is...

What would be the value of NLS of a job that is developed in a non NLS environment and imported to an environment with NLS?

It should ideally reflect the value that is defined in the project right?


Thanks

we require NLS for the other project that we have,hence we installed NLS.


Thanks
Vimali

Hi I have set UTF-8 as the default NLS value for a project in DS Administrator. I imported and recompiled the jobs that were devloped without NLS,to this project.But the NLS values in the different stages of the job do not reflect the Project Default(UTF-8). Any inputs on this is highly appreciated....

Ernie

In any case the values have to be populated to independent relational tables?


Thanks

Any inputs on this query?