DSXchange

Hi , I am writing data to xml file. we get data from different tables and needs to append the different xml chuncks from different tables to final xml. I have 2 records coming from the incoming process 2 records have same amount- the oout put from the xml is like this, <CvrTypeInfo> <CvrPlanName>DEN...

Thanks anbu for your reply.It did work, but I need to truncate leading zeros. when I tried with decimaltostring function it is truncating both leading and trailing zeros.

Hi ,



When I write data (input filed (9,2) ) to XML output stage (target filed (9,2)), the trailing zeros were truncated. I did check with dataset as output stage, it retained trailing zeros.

Can you please let me know how to hande this before I send data to XML.

Thanks
Sri

Craig, Thanks for the reply When I did full outer join I am getting 4 records instead of 3 This is the query I wrote SELECT A.EMPLID,B.EMPLID,A.EFFDT,A.NAME,B.MARITAL_STATUS FROM TABLE1 A full outer join TABLE B on A.emplid=b.emplid where B.EMPLID='XXXX' AND A.EMPLID='XXXX' I think UNOIN will be sol...

Hi Ray , thanks for your reply. Sorry for the confusion.Actually I am getting data from more then 2 tables. right now I have 4 tables but in future it may increase.I think I can't use the full outer join on multiple tables with the simple query.Can you please give me the idea how to implement this l...

HI All, I have to load history data into person dimension table from 3 sources. Data is like this table1 emplid effdt name xxxx 01/jan/2001 abc xxxx 06/jan/2001 abcd emplid and effdt are key columns table2 emplid effdt marital_status xxxx 01/jan/2001 U xxxx 04/jan/2001 M emplid and effdt are key fie...

Thanks Arndw For the solultion.I am working on this probelm right now

Thanks

HI , I am working on person dimension table. I have few questions regarding the data that is there in source table. Source table data EMPLID EFFDT NAME 100 01/05/2010 ABC 100 01/14/2010 ABCD 100 01/12/2010 ABCE -- this is back dated row. When I load the data into dimension table first two rows there...

Thanks DSguru2B for your Suggestion
It worked perfect

HI, I have to send one sequential file as an email attachement. I can send the attachment , but the problem is everything in one line my original file on unix like this JobName TableName "job1", "table1" "job2", "table2" "job3", "table3" bu...

Ray,thanks for your reply.my job is working.

Thanks

Thanks Ray and Craig I tested the routine in manager it is returning results without any problem. this is my job design JOB1 src --------------transformer -------------sequential I queried the record count of table into a column COUNT and passed to transformer in the derivation of the column called ...

Thanks Ray and Craig I tested the routine in manager it is returning results without any problem. this is my job design JOB1 src --------------transformer -------------sequential I queried the record count of table into a column COUNT and passed to transformer in the derivation of the column called ...

Hi , I need to pass values of one variable to another job. by going through previous posts, I got some idea about using DSSetUserStatus . still I don't understand how to use it. I have one job say JOB1 which reads record count of the table job is like this oraclestage--------------- transformer ----...

Kenneth, I am going to follow the 3rd option you suggested in the last mail. can you please give me some idea how to do this without using unix script and routine stage. Actually I wrote one unix script that queries data from the table and returns 1 if there are any records for today else 2 .I will ...