DSXchange

Thank you for immediate reply. Please assume that file1 is source file and file2 is the reference file.the scenario is such that the record may be present in source and reference files as well.this is not the case of missing files.if the record is present in reference file,irrespective of source fil...

Hi Everyone,

Greetings!

we are have two files file1 and file2.
Our requirement is to compare these two files and give the below outputs:

If the records match, give the output from file2.
If the records do not match,give the output from file1.

Could you please suggest a way to achieve this.

hi, we are facing a wierd problem where we have a teradata source with 7000 records. the query used to retreive these records is user defined. when these records are loaded to a dataset, the count is increasing to 200000. in the source query there is a date condition mentioned as DATE'#ps_FSR_R3P_DT...

Thank you very much for your quick reply. This resolved my issue..

Thank you very much for your quick reply. This resolved my issue..

I am facing the below scenario. I am having a source table ABC having columns col1,col2 and col3. I am having a lookup table 'ABC_Lookup' having columns col1 ,col2,col1_key and col2_key. I am performing a lookup for ABC table on 'ABC_Lookup' table on the columns col1 and col2 to retreive the col1_ke...

Thank You Ray.

Thank You Paul and Chulett for your responses.

Is there any way to transfer a Zip file in Datastage without going for a script?

I have chosen Datastage for this task as I have to do this as part of a Job Sequence.

Please let me know the options of achieving this.

Thank You.

Hi, I have a URI which lists a set of Zip files. I want to move these ZIP files on to a folder in another unix server. I want to use FTP stage by specifying URI as the source ,but I am not sure of which stage to use as target to move the zip files from URI to the unix folder. Could you please sugges...

Hi, I have a source file with columns productname,saletype,start date. Based on these columns I have to calculate end date for the corresponding records. If the product is only one record,the end date should be 1-9-9999. Else teh end date is one day previous than the next record's start date. Below ...

The SQL is used is pasted below: delete from cis_s_brands_dim where (brand_name in (select brand_name from s_brands@#$Stg_Db_Link#) and brand_name in (select brand_name from cis_s_brands_dim where record_loaded_from = ' ') and country_code in (select country_code from s_brands@#$Stg_Db_Link#) and co...

I just got a problem and a solution in relation to this topic. FYI: There is a before SQL defined in the target DRS Insert stage. This does a delete operation based on the condition written. In my case,the job is working sometimes and it is not working sometimes giving the below error: Invalid field...

I have a job where in I am retrieving data from an oracle table and doing an insert/update to the target table using change capture. All the stages are Dynamic RDMS stages. When I execute the job, I get the error as: Invalid field type in call to getInputFieldAsString() for field '4' in input datase...

Thank you .. I got it.

I am having a scenario where I have source data that is retreived from union of 5 tables. The table names are not part of the source data.
In the target, I have to load the source table name from which this data is retrieved.

Could you please suggest me how I can classify the data.

Thank You.