DSXchange

Suggestion 1 passes 0 records.
suggestion 2 passes all the records that I have in the input.
suggestion 3 passes less number of records the the count I have. However this was much closer but this gives only those records in output where keychange=1.

None of these suggestions worked. This is a typical example where I am not able to find any specific suggestion in any forum. I would also like to add that the COL1 may not be always +1, in actual it can be 10,15,45,64 etc

Example: Input: col1 col2 col3 col4 10 10/01/2011 10/31/2011 2 10 11/01/2011 11/31/2011 2 10 12/01/2011 12/31/2011 2 10 01/01/2012 01/31/2012 2 11 10/01/2011 10/31/2011 5 11 11/01/2011 11/31/2011 5 11 12/01/2011 12/31/2011 5 11 01/01/2012 01/31/2012 5 11 02/01/2011 02/31/2011 5 11 03/01/2011 03/31/2...

Hello Group, I am using XML output stage. My ouput at this point is 1 and my desired ouput is 2. Please let me know what needs to be done in order to get an ouput like 2. My header are repeating , but my requirement is to have the header(open and close) only once and the childs to be repeated for ev...

I have a scenario where I am generating an xml as output and have input columns coming from the transfomer. At this time, I am using the new xml stage (green and silver symbol). I would like to know as how can I insert a job parameter listed in the job properties to a header attribute of the xml. Ri...

I need a higher level answer to this please.

I have a scenario based question. I have an Input ID and want to add a seqID for every duplicate. If there are no duplicates then seqid should be 1 else if duplicate is found then increment seqid by 1. Below is the example of how the input and output may look. I would appreciate if someone could hel...

Can anyone help me on the above???? Or this is going to remain as an unsolved issue??

The datatype for reference link, input stream and output are timestamp and microseconds(extended). I went through all the post but none of them helped me. Also, I am able to view the data on my reference as well as input stream. Data from both streams come from a db2 database and I am using a db2 co...

This doesn't Help me. Could someone please look into this error and give me a solution please.

I am doing a lookup on ID field. Both, input as well as reference have datatype timestamp length 26 , scale 6. When I run my job I am getting the following error Lookup_103,1: Field "ID" has keyprep export format error; value: ************************** Lookup_103,1: Failed keylookup on ta...

Input is Date.

How can I convert yyyy-mm-dd TO MMYYYY in DATASTAGE??

These responses don't help me as I was looking for a generic solution using a stage variables. Some of them are partially correct but still don't give me a complete solution to my problem. Nevertheless I had to use a lookup stage and left join on PNO with the same table where cno=0 and dno=0 and gra...

Yes, I was meaning that in the lookup stage previously, I had set the input and the reference links sorted on a key. That time the job ran fine.
For the next run, I removed keys from both the links and the result was the error above. Hope this is clear!!!