DSXchange

Hi,

i am trying to do Http GET request to IGC rest API from Angular. how do i need to pass credentials along with the http GET request. Please let me know if i need to pass the credentials in header or is there any other option to authenticate? Thanks.

Thanks Ray. I am planning to do in DataStage. is there an option to pass if else statement as a parameter to transformer. In transformer, i have stage variable - svCheck svCheck - if isnull(link1.columnA) then 'Y' else 'N' when i tried to do by passing parameter, its not taking. In Job property - i ...

Hi, I have a dataset with 100 columns. I have about 20 rules to check whether the column is null or blank. Each rule will be using different columns from a source dataset. for each rule, I need to create 2 files one with empty values and other with non empty values. I am thinking to create one job a...

Ray, i searched in DSXchange, but most of the contents are blocked. Hi chandra, i am fine. how r u? i have around 1000 of jobs in one project, we have around 8 projects. its very difficult. yes even i tried to export the job in xml and open it in excel, it was easy to apply filter and find. but we c...

Hi Ray,

Thanks a lot. could you please send me the query.

how could we find from SQL queries. what would be the OLETYPE for ODBC, DB2 and Oracle stages.

shall we describe the tables (i.e column definition) in the universe database? so that it would be easy for me to explore a bit. Thanks again.

Hi All, i would like to find the list of jobs where certain hard code values are entered in transformer (in derivation and constraint) and source db2/odbc (in queries) stages.. jobs impacted : server and parallel. version : both 7.5(windows) and 8.1(unix) how can i get the list of job names just by ...

job is simple... sequential file as input and output... and transformer in between.. ok if i go for a round robin partition in transformer.. how can i check the count of record processed in each node... ?

first question : if my target is database then it is fine.. if my target is sequential file then what to do...? my second question : suppose input record is 10 million, job got failed after 9 million... when i run the job again it has to update 9 million record right.. updating 9 million record is v...

if any one having good document which explains very basics about partitioning. let me know... i searched in google.. i didnt get what i expected....


thanks in advance...

i am new to the concept of partition. please help me... 4 nodes are defined in server... how could i distribute the input records to the 4 nodes... for example 1000 rows are coming from input, i would like to distribute 250 rows to each node... is it possible to achieve this.. if this kind of questi...

DB2 database and write mode is insert..

i can switch to ODBC connector stage... that is not a problem....main concern is the record level commit... is there any option in ODBC connector stage...?

hi.., I am new to datastage... please help me in this issue.. I am using ODBC enterprise stage in job. job is very simple, direct mapping from source to target... Source is having 10,000 rows, if the job gets aborted after 5950 rows. the rows are getting committed in the target. my need is it should...

the data in column contains alphanumeric characters and special characters... i would like to remove the special characters from the data... is there any option in datastage...

please help me in this issue....

my question is why the null values are getting dropped....? why its not going to target...??? any setting has to be done in transformer..?????

if the column value is NULL... its getting dropped... its going to reject link from the transformer.. i am not doing any null handling.... as of now i am using stage variable, constraint and sending to target.. but without that i wants to send to target....