DSXchange

So from 8.7 , we don't have that feature?

Hi, When I worked on DataStage Version 8.1,I noticed if there is any invalid column mapping or incomplete mapping(or un-mapped column) in any stage(Like Transformer/Lookup) , that stage used to have yellow Exclamation mark . Now in DataStage 8.7/9.x I don't see that . (Job gives compilation error as...

Hi, I am trying to load a table(SQL Server 2008) using ODBC Connector Stage with load strategy : Update then Insert. I have Trigger written on the table(Table I am trying to Update), which updates another table i.e. I am trying to Update Table_A and Table_A has a trigger Trig_A which updates Table_B...

Hi, I am reading an excel file using Unstructured Data Stage , but when I am reading file , If I am trying to parameterize file path , it is giving error and also I want to read the file using file pattern as file I receive daily comes with Date_timestamp in File name like Test_File_<Date_timestamp>...

Hi,

Thank you for reply.

I have filtered the header in Transformer stage , job is working fine , but just wanted to check if there is any option /parameter where it will treat header of each file as header while reading using file pattern.

Thank you.

Hi, Thank you for response and sorry for delay in my reply. I am trying to load multiple tables(Target) in same job (few tables has FK define) I tried the find option Record Ordering, but I couldn't find that option(in Target Oracle Connector Stage) , can you please or link ordering in (copy stage)....

Hi, I am trying to read multiple file of same layout and similar file name using File Pattern of Sequential file stage. All the files has file header , I defined First Line has header in Seq file Stage, but it is considering header of only 1 file , for all other files , it is still reading header as...

Hi, I am trying to load multiple target table , and I have Foreign Key defined in few tables. Is there a way I can define load order (Load all the tables in same job). I tried to search for post on same topic and found below , it says it can't be done: http://www.dsxchange.com/viewtopic.php?t=135513...

Thank you for your reply .

I am running the job in default node (my Apt_config file has 2 nodes).

I tried to do hash partition on unique key column also , still it not working.

Thanks,

Hi, In a job , I am selecting from a table and after few transformation , trying to update 1 field of same table (i.e. updating the same table where I am selecting records from). My database is SQLSERVER 2008 and in select query I am using WITH (NOLOCK) and in update query , I am using WITH (UPDLOCk...

Hi, I am using Unstructured Data Stage to read an excel file , can anybody tell how to parameterise file name . I have already tied to use Use Template file for design option to read file similar to reading using file pattern of flat file stage. Can anyone please help me with reading file with file ...

Hi, I was trying to create N no of files from a files (where N is no of records in file). Below post was very useful: http://www.dsxchange.com/viewtopic.php?t=133224 I was successfully able to create N no of files , but those files didn't have header. Is there a way to add header to the files in dat...

Hi,

I am not much familiar with Quality Stage components of DataStage,Can anybody please let me know if we can use multiple conditions (like I am trying if COL_1 in (1,2,3)) in Survive Rule ,single rule.

Thank You

Hi, I am trying to implement same logic , while searching I found APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS When set, DataStage will reject any string or ustring fields read thatgo over their fixed size. By default these records are truncated. I set that parameter, still my varchar records are not rej...

Hi, I want to make few jobs of project readonly. I took export of the jobs (need to make readonly) and opened dsx files and changed Readonly flag to 1 from 0 i.e. Readonly "1" Than imported the dsx, still my job is not readonly (it is in editable mode) I don't want to restrict the project....