DSXchange

Hi, I have a sequence in which two parallel jobs are called in sequential manner. First job will append to a dataset. Second job reads from the above appended dataset and write to a sequential file. When i run this job normally,i dont see any warnings. If i run the job in parallel instances of 2 ,i ...

I eliminated @FM and it is working fine.
Thanks a lot.

Hi, I am using a script to check two conditions.If condition1 is met i am doing echo 0 .else if condition 2 is met i am doing echo 99. Then based on above echo value i am triggering two different jobs. my job looks like this. echo 0 execute_command----------->job_activity1-->notification_success | |...

Hi, I have a job to take data from source ,lookup on a dataset,if no corresponding entry is present,append that record to same dataset by assigning an unique index to it so that the dataset have unique records.. My job looks as dataset | seq_file---->lookup---->dataset When i execute the job,i am ge...

Thanks a lot Rohit.I enclosed password in double quotes.it worked.

Hi, When i am trying to use surrogate key generator to generate the PK by calling oracle sequence,it is giving the following error. APT_CombinedOperatorController(4),1: Caught exception from runLocally(): APT_ParseError: Expected "," or "}", got: "abcd", line 1. here &q...

Hi, This is resolved.I tried the following. records with same F_N is taken in one partition by selecting appropriate partioning method. Stage Variables: next = F_N ic2=if (next<>prev) then '' else c2 ic1=if (next<>prev) then '' else c1 c1=if ELEMENT_NAME='ID' then VALUE else ic1 c2=if ELEMENT_NAME=N...

Thanks Kryt0n.I will try the above logic and let you know.

From the source i will be getting 3 columns
F_N,element_name,value
1,ID,13
1,Name,xx
1,Place,yy
2,ID,16
2,Place,zz

The maximum number of element_names for key column F_N is 3.
So,output should be
F_N,ID.Name,Place
1,13,xx,yy
2,16,Null,zz

I have never heard of Vertical Pivot stage in any DataStage version. . Hi Kandy, I mean doing vertical pivot in pivot stage only. Actually the earlier post was to pivot the source data irrespective of number of records. now,i need to consider maximum number of records (in sample data,it have shown ...

Hi, I came across the post saying http://www.dsxchange.com/viewtopic.php?t=145198 that it can be done in a transformer using loop variables.Could anyone please give an idea how can i achieve this? and get the following output. ID,Item1,Item2,Item3,Item4,Item5,Item6,Item7,Item8 001,a1,Null,null,null,...

Hi, I have the requirement to convert rows to columns.So,i used vertical pivot stage.But it works when the number of records for each key are same.But,my input is as follows. col1,col2 1,C1 1,C2 1,C3 2,C1 2,C3 So,output should be 1,C1,C2,C3 2,C1,Null,C3 Please suggest me how can i do this in vertica...

Hi, I need to create output files for distinct values in col1 and put corresponding data into those files. input file: col1,col2 1,xx 1,yy 2,zz So,i read the posts and implemented the logic by using the awk command awk '{nPosField1=index($0,",");print substr($0,nPosField1+1)>substr($0,1,nP...

Thanks Ray.It worked.

Hi,
I have a requirement to add quarter day to the current timestamp
if current timestamp is 2/28/2012 10:32:17 PM,
my output should be 2/28/12 10:32 PM+(1/4)=2/29/12 4:32 AM
Please suggest me hoe can i achieve this?