DSXchange

Hello, I am using Oracle connector stage my insert statement have reserved word column DEFAULT..when I run my job it gives me error ORA-01747: invalid user.table.column, table.column, or column specification when I put "DEFAULT" in double quotes it gives me error ORA-01745: invalid host/bi...

Thanks Ray, We can increase the Terminal connection but max 10. Since the number of projects are increasing the headcount will eventually increase and each member has to access the server. Remote connection makes more visibility to engine in contrast to command prompt. So we are looking for a third ...

Like on unix box, we use putty software to connect to Infosphere engine for ETL developers as they need to develop scripts for the projects. DO we have any options for INfoshphere engine installed on Windows 2008 R2. Currently ETL users are doing remote connect and at max 2 people are able to connec...

Thanks for reply Ernie...

Resolved, each of the sub elements needed a separate input stage where in , I combined later to parent elements using common attribute with join condition.

hi, my xml is as follows.. <ComplexXML> <LevelElement> <elementattributes name="level1" col1="a" col2="b" col3="c" > <subelements> <col4="d" col5="e" col6="f"> <col4="g" col5="h" col6="i"> </subelemen...

Hi All, I sorted the data on ascending product(PRDNAME) and descending amount and Keychange column is always is giving as 1. Sort stage --------------------- Key =PRDNAME Sort order = Acsending Key=PRDAMT Sort order= Desending Hash Partition = PRDNAME PLease help me whethere iam missing anything to ...

Hi All, I need help in compare two date fields in datastage parallel job transformer stage Both the start date and end date fileds are NULLABLE NO yes fields. Example ================ start date :2015-12-20 End date :2015-09-19 I just want to know whether start is greater than End date in datastage ...

I sorted the data by ascending product and descending amount.

Plesae tell me how to do ( Do a key change on product in the sort stage )as well.

Guys, any help on this

For different products (PD1,PD2,PD3) the rank to be generated .
If i sorted the data on ascending product(PRDNAME) and descending amount. Then keychange will always give '1' .Then how can i generate rank for other group .

For each different product rank should start from 1 .

I sorted the data on ascending product(PRDNAME) and descending amount. In this case Keychange column is always is giving as 1.

Please help me on this logic

Guys please help me on this logic

We can generate number after combining two files source but , how to generate SERIAL values for SOURCE2 . Rule for SERIAL column Generation : Number generation should be started from SOURCE1 starting from 10 and increment by 10 for the records DEPT wise. For SOURCE2 the SERIAL column should start fr...

Hi All, I need some help to implement below requirement Please find my requirement with above sample example. Iam having two input files "file1" and "file2" comma delimeted file and i need to generate SERIAL column after combining both files. SOURCE 1 ============== DEPT , EMPNO ...

When I choose the Data Element as XML , then it was throwing error as "the data element selected is not compatible with the SQL data type". So, now the issue is when I edit the xml file in note pad , every thing looks good , but the spaces are stripped , making the xml content as long stri...