DSXchange

Hi, I have scenario in which i need to develop a SCD type2.Here i have table in which colums are as follows:- SGTKE(PK),PARTY_ID,SEG_ID,R_ID,MANAGER_NAME,START_DATE,END_DATE 1,1,111,2,A,2009-07-10,NULL 2,6,123,B,2009-07-10,NULL 3,5,078,C,009-07-10,NULL Now i need to capture the new records basced on...

Create a stage variable say svCount intialize it to 0. in derivation put if svCount=0 then col1+1 else svCount+1 reiterating words from my previous post also what sainath told that if you want to increment that value for each record them its best to use surrogate key. Thanks a lot........it resolve...

Sainath.Srinivasan wrote:Run the data through a sort stage and add 1 in a transformer.

Note - this is the idea for single node run.

For multiple node, you must partition the data by proper key columns and add (partition ...

can you please tell me the logic for adding 1 in transformer..??

have you tried searching the forum? stage variables is not a good option unless you have to reset the counter depending on keys on key partitioned data. If you just want to generate a sequence number use surrogate key generator stage or surrogate key functionality of transformer. Yes i want counter...

Hi All, i have a source dataset in which columns are two like this Col1,Col2 1,A 1,B 1,C and i want to develop some logic in transformer,so that my target data will be like this:- Col1,Col2 2,A 3,B 4,C Can anyone help me to do this using stage veriable..???or is there any other way out to do this..??

Is this still true? And is the error exactly the same? If not, post it. This code is working fine for case: 1,2,3,4,5 but in the case of 6,30 my job get aborts yes error is same when i call case-6,job aborts with error mesaage "APT_CombinedOperatorController(2),0: Operator terminated abnormall...

Edit the original post and fix your code tags. Your closing code tag is incomplete. ... I have made the code small........but still the problem is same......it is working well when i run this same code in turbo c++ compiler but when i call in routine its gives error...i think it is not able to call...

Sainath.Srinivasan wrote:Make the code write incoming values into a file so you can cross-check the failed values. ...

same error i m getting.......

hi all, We are trying to make C++ routine,we have developed a code ]#include<stdio.h> #include<stdlib.h> #include<string.h> #include<conio.h> char * substr(char a[] ,int s,int l) { int i; char * b; b=NULL; for(i=s;i<=s+l-1;i++) { b[i-s]=a[i-1]; } b[i-1]='\0'; //printf("%s",b); return b; } ...

Below mentioned is the example how Pivot stage works... The input link Columns page contains three input columns with sales data: JAN_Sales, FEB_Sales, and MARCH_Sales. The columns are as follows: The data for the source rows for the input columns looks like this: Input Source Rows CUSTID LNAME JAN...

Hi , I have one scenario in wihch i have to pivot rows into column.And i have no idea to use a PIVOT stage. I have like this:- i/p:- col a b c d val 22-44 33-32 99-88 55-11 and i want o/p like this:- col1 col2 22 44 33 32 99 88 55 11 please help me in resolving this scenario.. Regards

It's not as far as I know. There is a Java PACK that will allow you to do things like this but it is a option you need to purchase. Perhaps with a build-op? :? Hi Chulett Thanks for ur reply,Ok but i dont know how to use buildup stage,can u please help me writing this code in buildup stage and exec...

Hi, I have a java code with name Sum.java code:- class Sum1 { int RetSum(int a1 , int a2) { return a1+a2; } } class Sum { public static void main(String args[]) { Sum1 a=new Sum1(); System.out.println(a.RetSum(10,20)); } } when i coplied this code it generates two class files Sum.class and Sum1.clas...

Hi, I have a java code with name Sum.java code:- class Sum1 { int RetSum(int a1 , int a2) { return a1+a2; } } class Sum { public static void main(String args[]) { Sum1 a=new Sum1(); System.out.println(a.RetSum(10,20)); } } when i coplied this code it generates two class files Sum.class and Sum1.clas...

miwinter wrote:... and the format options you have set?

Yes......data is in tab delimiter format and i have set it properly in seq src.