DSXchange

yes..lokesh ... i also try to find it in the operator reference and other help docs.. it is not specified anywhere that how it sort in UNIX... wether it sorts on the basis of Primary key or secondary key.... or both if anyone find something on this pls share, but ideally what we do is that we use da...

Hi, Which version of EPM are u talking about.. For Peoplesoft EMP 8.9 If u see there are categories in the Datastage project go to CRM datamart folder,if i remember correctly there are some staging jobs for CRM in Hundreds,first u have to run those jobs after that data get loaded in the source table...

Hi , We are trying to read a fixed format binary file where each record length is 80 bytes. We are trying to view the data as CHAR (80) as we need to have some special conversion rules. So now if we are trying to view the data it is showing only the first record i.e. first 80 bytes and rest records ...

Thanks everyone,

My problem is solved by using Transformation operator in Generic stage,

Regards,

Devesh

In addition to what Akhil has said, for link order just go to transformer stage properties ,there you will find linkordering tab you can select link order there ,

regards,
Devesh

Thanks for the inputs everyone(Ray,bcarlson,cyh) Ray, i dont think that it will work for us ,as we have more than hundred different layout in input, Is there any way out through which we can do tranformations in the Schema file which is fetch by sequential file without mentioning the columns in the ...

Ray, I will be more than happy :lol: if this can be done without buildopstage, as for now my problem is to generalize the job for all the retailers(parameterising the job),if there are other approaches to solve this problem do suggest , Again I am explain my requirements : We have to design a Datast...

Arvind, For your problem easy solution is to use filter stage directly and 1: If you want to run multiple instances of the job then parameterise the job i.e. in filter stage pass column in where clause and parameterise the where clause with country name,and specify the output link,and in the out put...

Thanks for your input , but it is not possible for me to write a job for all the retailers as there can be 800+ retailers ,so what i want to achieve with this job is 1:parameterising the input with retailer's schema file and 2:mapping them with the output fixstructure layout in the buildop stage( is...

I think ,it will not solve my problem as i need to add columns for some of the retailers(files),moreover i cannot change the columns as this is some retailer's file,we will be using file as a source , columns are : A B K F here K= C+E ,if c is notavailable then only E and viceversa, and if both are ...

Thanks Chulett ,Ray and Vincent,


Regards,

Devesh

Hi,
I am not able to view any Parallel job in job category of Reporting Assistant ,I can see all the server jobs there but no parallel job,

Is it a feature or bug



Regards,

Devesh

hi I am facing the problem in implementing this logic: We are building a buildop and our requirment is : We want to change the table structure at runtime in the Input of Interface and my output interface schema is fixed ,can it be possible in buildop stage ,or is there any other way to solve this pr...

Kirti,

Can u explain combinability mode in more detail,
What do you mean by combine the operator with other stage if possible,
Please explain this with some example,

Thanking you in anticipation,

Regards,
Devesh

Hi Ray ,

can u please tell what u are talking abt replacing Category name in Repository,

If there is any short cut to do category name change directly in repository,please share it,



Regards,

DevesH