DSXchange

Thanks for the inputs Ray! Loop and then Outerjoin worked

Hello Folks, Need insights on approach for this I have the below file which will have a Column1(which is like a Key);Date(Every Monday of the week);qty I will need to have "N" number of weeks qty for each Column1 Key Value Example Data: Column1;Date;Qty 1;01222018;2 1;01292018;3 1;02052018...

Thanks for the answer Mike. Actually, it is a 4 character column. And it can be 1 character or 2 character ..or 4 character. So, I need to do look up based on what I have in the Table. So, I am thinking starting a lookup with 4 character and then the rejected one goes to another lookup with 3 charac...

I have a Input file with a Key Column which should be looked up into a table which sometimes might have a starting letter or a full string. So, basically I have to use LIKE for lookup which we don't have in Datastage. Any thoughts on how to accomplish this. One way is to load my input data into anot...

Try first using SOAP UI to check if web service call is actually working or not

Write them as varchar values. It worked!

Sales force Object has Boolean data type fields which need to be loaded using Datastage.While trying to import the field definitions of object using Sales force connector, it defaults to Varchar data type fields. I have manually changes the data type to Bit and tried to load the object, but all the ...

Any thoughts?

I have a Row Generator and then a XML Output stage ROW_GENERATOR Stage -----> XML Output Stage In the Row Generator, I have the below two fields ID: Integer->Description Field: /Member/Person[@Type="ID"] Name: Varchar -> Description Field: /Member/Person[@Type="Name"] Next, XML O...

But just by using a XML Output stage, writing different attributes values for the same element is resulting in the output mentioned in the question. How many ever attributes I have, its defaulting the first one and then rest of the values are written underneath it <Member> <Person Type="ID"...

I haven't used XML Transformer stage, Just figured out it might be bale to achieve using that. Will try that out!!

Define Environment variables (in Admin) and then use the same variables by defining as parameter set and then use the same parameter set across all the jobs. I think that will make defining variables in each job easier.

I have to generate a XML file as below by reading the values from a text file Text File:(Some delimited file) 123|John XML file to generate: <Member> <Person Type="ID">123</Person> <Person Type="Name">John</Person> </Member> XPATH I am using in XML Output stage for respective col...