DSXchange

The set of values in column-2 is dynamic. Some times it may ave 1 value and at times 50,100, so on.. Is it possible to use pivot for dynamic number of columns ? Please help steps if possible.

Looping is not available in 8.1. I believe this is available from 8.5. Can you please suggest alternatives.

Hi I have a requirement to process following: I/P: A1|val1;val2;val3.....;valn|C3 B1|val2;var3;var5;..........;varn|C3 O/P: A1|Val1|C3 A1|val2|C3 ... ... A1|valn|C3 B1|val2|C3 .. .. .. B1|varn|C3 Hear the 2nd column has unknown number of values which has to splitted across for each of the value in c...

I have a requirement to create a pipe delimited sequential file out of a table extract. I have a table with 150 columns and I'm using column export stage to cretae the file. In this process, I have to go look the order of columns and select from the properties , manually add each column in the same ...

I need to export Columns/Layout information of my Input Tables and Output file extracts into a CSV file/Excel Spreadsheet
Plz suggest me how to do.

We have some source files in our DataStage ETL from AbIntio upstream application. Now the source team is providing us the Metadata of these source files in the Abinito format files -- abc.dml. Is there a way to import these files in Datastage. We are following very tedious way to look into the file ...

I have a requirement to unload data from n number of tables (say 50) from one Environment (say PROD) and insert into the tables in other environment (say COB). For that unlike developing 50 DS jobs with each table metadata included in each of these individual jobs, is there any way to use a single j...

Hi, I have lookup criteria where I have to implement a business transformation on the output filed if the lookup is success. And implement a different logic if the lookup fails. Normally, we used to have a flag from the Lookup stage. And based on the flag value, we will implement the Transformation ...

Thanks for your replies.

As suggested, I'll go with UNIX Shell script.

Hi, I have a requirement where in, I need to execute UNIX command for every input record from a sequential file. The output of this command has to undergo transformation. This is one of the sample : I need to generate a sample report of space available and used for Each UNIX directory, list of direc...