DSXchange

I have not used the file stage till now.Can anybody tell me one practical example where i can use file stage which is not possible with dataset and sequential file? I read so many posts in this site and also theory for fileset. I am very clear with the differences between all of them but i am not ab...

what is meant by with 12 writes?

lkomala wrote:My OS is windows

You can use MKS tool kit also.Use following link or google for more information

en.wikipedia.org/wiki/MKS_Toolkit

I want to know whether following things are possible using MetadataworkBench tool.In our project we are using oracle Database,Datastage and Business Objects reporting tool. 1)I want to know list of Datastage Jobs using particular table or column in oracle database? 2)Which reports will be effected i...

I think you can use Output of Uservariable activity or Execute command activity output in Wait for file activity.

I am trying to understand the script.Not sure what are values i need to pass for the following parameters. ParameterFile="${2}" FileSetDate="${3}" BatchNumber="${4}" JobHierarchyFile="${5}" SourceSystemList="${6}" SubjectAreaList="${7}" Cle...

It is perfectly working.Thanks

@Eric

I do not have any issue to use the constraint but what craig provided is generalized solution which will handle any volume of data

Not sure how to proceed using MOd fuction after thinking for long time

source is sequential file. Requirement: Input file's data should be distributed like 1st 3 row in file1, next 3 row in file2, next 3 rows in file3 again next 3 rows in file1 and continues. Currently we have less records in source so i generated rownum in sequential filestage and put constraint in tr...

@ssnegi.Thanks for input.Just want to know am i missing something
because Roland mentioned to join based on empno and rownum?

I am not able to get required o/p after joining based on EmpNo and rownumber.Not sure what i am missing


stream1 o/p:
salary,EmpNo,rownum
1000,10,1
2000,20,2
3000,30,3
4000,40,4

stream2 o/p:

salary,EmpNo,rownum
1000,10,0
2000,20,1
3000,30,2
4000,40,3

@ray

Is promote this informational message to warning will work for any no of rejected records?In this example no of rejected records are 3 and 4 will it work suppose 10 records are rejected?

@wittyme

Interesting and eager to know how you decoded the passwprd?

In 9.1 we can split the file based on key but i think we have only unix split command option. In one of post i read we can use Folder stage in server jobs to split a file but not sure exactly

@Clarification 2

where is that property to choose not to add reject links at all to the Merge stage