DSXchange

i am trying to understand the rule set.stuck up with following questions. USNAME RULE set: classification: ;;QualityStage v8.0 \FORMAT\ SORT=Y ;------------------------------------------------------------------------------- ; USNAME Classification Table ;---------------------------------------------...

We are facing Issue in the Referential Integrity Detail Report.When we generated Referential Integrity Detail Report between two tables which is not having any virtual columns.we do not have any issues but if we generated Referential Integrity Detail Report between two tables which is having virtual...

Thanks and it is working.It is generating 3 files with name as 1,2,3.Is it possible to generate 1.txt,2.txt,3.txt without renaming the files

Thanks for Input.I can generate multiple files by using below setting Rootfilestring-path is mentioned here key=emp Usevalueinfilename=True The outpur files are generated with following names 1.part00000 2.part00000 3.part00000 but what i need is 1.txt 2.txt 3.txt Source file empid,empname,sal 1,a,1...

i have selected WriteMethod=Generate Multiple File for generating multiple files based on key.Job ran successfully but i do not know where the files will be created and also i do not find option to mention path for target files?

what do u mean by X and Y.Do u mean different versions of DB

I am using below routine to calculate the no of records in a file but it is throwing compilation error Function CheckFileRecords(Arg1,Arg2) vParamFile = Arg1 : "/" : Arg2 vCountVal = 0 OpenSeq vParamFile To FileVar Else Call DSLogWarn("Cannot open ":vParamFile , "Cannot Open...

I think TimestampOffsetByComponents function should work

Tried all the above options but still facing same Issue.

Filter stage is not working properly in my case..design is as follows: sequential file -->filter-->two sequential files(where1 and where2) i/p: EmpNo,EmpName,DeptNo 1,ABC,10 2,BCD,20 1,ABC,10 filter properties: where1=DeptNo=10--link0 where2=EmpName='ABC'--link1 outputrowsonlyonce=false i am excepti...

Are u facing same Issue if u are using IStool or Information Server Manager?

1)Get the distinct values in column1 using unix or datastage.Write them into some text file.

2)use looping in jobsequence to iterate for each value present in text file.withinlopping pass the value as parameter to jobactivity

I have raised one PMR to IBM.They need following information from me to further investigate the Issue?How to get below information

- SystemOut and SystemError logs
- iasServer and iasHandler logs

I tried creating virtual table and i do not find any difference between these two and also I do not find any option to join two tables before doing column analysis

1)In IA we can define where clause for a table in Analysis setting for a particular project.We can also create a separate virtual table with where clause for table.what is the difference between these two?Pros and cons between these two things 2)Is it possible to perform column analysis after joinin...