DSXchange

Once again, Please post descriptive posts

You are not getting any help by posting this kind of questions.

Welcome aboard :D You seem to be new to DSXchange, So when you post something, be specific about what you want. By doing this you are helping us help you. Now, with what you have posted I am assuming that you want to take backup of datastage code (jobs, routines, etc,.). You can do this using the Da...

Now, somebody is giving Ray and Craig some competition

No offense! I can not afford offending you guys

Your logic is not clear from the example you've posted. I am assuming that you want to send the records which DO NOT have a NULL in column 1 in the output and that you don't want duplicates on col2 in the output. You can read the file through a single sequential file stage (by adding two File proper...

That's good info, I thought all the versions from DS 7.5x2 onwards can be installed on a Windows server.

ray.wurlod wrote:The dsrecords command is available on all platforms. It has an undocumeted -n option for returning just the number (not the "records" word). ...

Ray, How did you learn about so many hidden tricks ...
What's the secret?

If I am not wrong the OP at first wanted the data to be collected from each link and dump the output on the output link i.e. take the data from the first input link and dump it on the output link then do the same for the second, third and fourth links. And then the "requirement" has change...

Do any of the rows have a NULL value in the column which you are splitting?

Column import stage doesn't need any keyed partitioning because it doesn't work on any keys. So, you don't even need "Entire Partitioning". And if Entire partitioning is used, then you'll get one record repeated as many times as there are nodes in your config file. So, now about your probl...

If you set the funnel type to "Sequence" it should give you the desired output.
It copies all the records from the first input link, and then all the records from the second input link and so on....

Do a Trim(IsNotNull()) instead of a IsNotNull(Trim())

There is an easier way to get the count of records in a dataset.
You can run: This would give you the number of records in the dataset. We use this on a Windows server, I am not sure if this is available in DS on unix.

You've put up two posts without actually telling us what you mean by "virtual concept". But, I guess you might be asking if Datastage works on a virtual machine (as Craig guessed). You can run Datastage on VMware, I do that all the time (mine is a test machine). You shouldn't expect any di...

It's funny that if "Number of readers per node" is set to "n" it doesn't run "n" readers per every node. It actually reads using "n" readers on just one node. I guess the guys at Ascential didn't name it properly, It should have been "Number of readers pe...

All the stages present in the "parallel job palette" can be used in a parallel job. The palette you see to the left in the Datastage designer changes based on the type of job you develop, So when you develop a parallel job you can not (can not as in you won't be able to not that you should...