DSXchange

We have clicked the box for both keys....as well as we have taken care all conditions in hash file....

Unable to track the error . Please help.

Hi Gurus , I am facing the following problem : In my job the following sequence has been maintained : OCI stage ......> Transformer...>Hash File ...> From Oci stage 54 rows flowing same is from Transformer output link . But when we are viewing Hashfile data we can only see 2 rows We have 2 keys in H...

Hi , The problem i am facing is : The input file is not a fixed width file ( its a cobol data file ) I used CFF stage also to read the data means view the data.....i have some redifines and occurs clause . So i am not able to do that . Also suggest how to use redefines tab in CFF ( gurus pls answer)...

Hi All Gurus , I am doing a job where the following scenario is there . There is 1 source table (table 1)and one look up table (table 2) . These tables are joined on a key . Now in out put i am trying to update the same look up table (table 2) putting "Update or insert records" in SQL prom...

Do you want record counts for file 1 n file 2 in your output? Or you want physical records to be combined in out put file.......?? I fit so then use `wc -l` for file 1 and 2 then ...... If you want records then write a simple shell script as : cat $I1 > $O1 cat $I2 >> $O1 call it after Job subroutin...

Hi , If it is related to running a Shell script (Unix) Then you can do that using ExecSH option too . If that is permitted then just execute a after/before subroutine and give execsh option and in value give ur shell script path ( if ur script needs some parameters you can give along with that also ...

When you ask for some suggestion always give the error details . Still if you have followed the suggestion above means keeping the directory and file name same for hash while reading and writing and you still got error . Then just check your hash file it might got corrupted . I am not sure but i ha...

Hi even once i faced the same scenario once One way is CFF stage but i dont have much clarity on that.... I followed the alternate sequential file stage . i.e , Use the data as a bunch for which you have redifinition and slice it accordingly as per your requirement . Means if you have column positi...

I have the following scenario : Sequential file 1.....> .................> ODBC (update table) Transformer ODBC stage....> .................> ODBC (update table) I need to use a file and database(reference) as input and i need to update( or create two tables ) . Please suggest me what are the possib...

Hey ,

Use the below command :

when to save ur file in Unix do this :

:%s/ctrlv+m//

means colon then % ,then s then / ,then control v and controll m ,then double slash

enjoy

Hi Pravin I think u must be aware of the universal fact that look up works on key....and at same time the data u want to fetch cant be the key.....ok... So for ur case i mean if u want date in lookup(hash file if server edition) then what u can do is you can create a dummy column and validate the s...

Hi , If the qs is related to "how you can use parameters for file names or other things " then you can do this : You can click on Job properties tab and on that you can declare a number of parameters as : e.g, parmSourceFilePath and declare it as string and give some default value . And i...

Can you just guide me how we can handle this scenarion in px since i worked in server only......


Thanks n cheers

Hi ,

Let suppose you have :

Columnname Data
Emp_id 1234567

As per ur qs you need the third number from left and want to check whther that is 3 or not ?

Use this :

If Substrings(Emp_id,3,1) = "3" Then x Else y .


Cheers