Recent content by NatPV

Hi all, I'm trying to generate an xml file from a sql query onto Oracle 8.1.7 tables (via PL/SQL procedure). I have a problem. I read your news on xml file generation. I have tried to use xmlgen and dbms_xmlquery, but I haven't found a way to set more than one attribute for a node. For...

Hi all, I have a problem. I read your news on xml file generation. I have tried to use xmlgen and dbms_xmlquery, but I haven't found a way to set more than one attribute for a node. For example, I want to have: <Contract IDContract = 'XXX' IDCustomer = 'YYY'> But I don't know to to get this...

Thank you for replying, to all. So there isn't a solution if prompt are creted in the universe. I'll try to string order on the messages.... My regards, Natascia.

It could be the best solution if I have only one report on that prompts. But I have different reports, showing different prompt (of different objects) so, for example, I would have: 1:XXXX 4:YYYY 9:ZZZZ for one particular report. Thank you for suggestion :) I should find another way...Nat.

Full client, and the version is 5.1.6. Thank you for replying, Natascia.

Hi all, I'm working with promt, more than one. I have noticed that they aren't shown to the user in the extact order I put them in the query. Instead, they are shown in ascii order. Is there a way to order them as I want? If no, please let me know, and I stop my research... Thank you very much...

Hi AshishVinny, have you then found good documentation? If so, can you please tell me where? Thank you very much, Nat.

Hi Solukas, thank you for your answer. I have to load a time table (dimensional) and the fields have timestamp format. The table is stored in Oracle DB. I have used the ORAOCI stage and I did not have problems. When then I used the ODBC stage I wasn't able to load the table again. I used some...

Hi, surrogate keys are easy to generate both in Informatica and Datastage, and yes, thery are important for slowly changing dimension. By the way, in which way can I realize the slowly changing dimension in Datastage? Thank you for your attention. Bye.

I was wondering if anybody has some Datastage exercises othen than the ones of the tutorial. If yes, I would be very glad if you could send me it. It is very important for me. Thank you for your attention, bye. NatPV

Hi all, I'm at the beginning. I have to extract date from a file (in char format) and I have to store it in Oracle DB. The type of the destination field is timestamp 19. Well, the only row loaded is the first and the value for the timestamp is 0000-00-00 00:00:00. Then, whem I look into the...