DSXchange

@srinivas.nettalam


Input Method is-XML Content


any body input is really appreciated

1)I have one XML file which is having around 1000 columns and in target i need to load only 25 columns Externalsourcestage-->XMLInput Stage-->Transfomer-->oracle connector 1)In Externalsourcestage i am reading it as single varchar field.In XMLInput Stage do i need to Metadata for 100 columns or 25 c...

I have one source XML file which consists of 300 columns.This data we are are loading into 40 staging tables.All are one to one Mapping(No change in column Names between source and Target) but number of columns will differ in each table.Just want to know is there any functionality in transformer whi...

I am analyzing existing Job in Datastage.Could anybody please clarify below doubt with respect to Join stage? I have 4 Tables.These four tables are input to Join stage.Join type=Left outer.In link ordering tab following details are mentioned. Table1-Left Table2-Intermediate1 Table3-Intermediate2 Tab...

Difference between RawLength and Len function?

As far as i know RawLength function operates on Raw Data type and Len function operates on String data type.But i do not know what is meant by Raw Data type?Could anybody provide any sample data for Raw Data type to understand Raw Data type?

MQ connector stage is used to read messages or write messages from Queue.Could anybody please clarify below doubts for MQ connector stage 1)Is there any advantage of reading or writing messages to queue instead of reading or writing from files,tables,xml because so far i worked with these three(file...

I have 2.5 year experience in datatage as Developer.Now i got oppurtunity to work as Datastage admin.Please let me know which one is having more opportunities(Datastage admin or Datastage Developer) in the IT market.Becuase I am in Dilema to go for Datstage Admin or not?As far as My knowledge is con...

Thanks Ray.

could you please clarify the path installation doubt also?

In Unix we have various process related to datastage as below. 1. ps -ef |grep dsrpc 2. ps -ef |grep slave 3. ps -ef |grep JobMon 4. ps -ef |grep dscs 5. ps -ef | grep phantom 6. ps -ef | grep osh 7. ps -ef | grep dsapi Is there any manual or link which will give information about these process(dsrp...

We have various topologies while installing the engine tier, metadata repository tier, and services tier(Single computer topology,Client/server topology,Dedicated engine tier topology,Dedicated computer etc).I am not sure which Topology currently using in my project. Is there any way to find which t...

I have two fields in source cola,colb and two fields in reference colc,cold. I need to implement the below logic in Range Lookup. lkp.colc = src.cola lkp.cold > src.colb As of now I am implementing lkp.colc = src.cola using Join stage and then implementing lkp.cold > src.colb using filter stage.New ...

Thanks for reply.As far as my knowledge it will give correct output as per the orginial post

If keychange=1 and LastRowInGroup(InputColumn) then 1 else 0-Stv1

and use following two constraints

constraint-Stv1=1 for unique row file
Stv1=0 for duplicates file

Proper partition and sorting should be done.

Please correct me if i am wrong?

I think even i am using different value files [ex-valuefile1 consists of parameters related to Test environment and valuefile2 consists of parameters related to Production environment] while running the Job depends on environment I have to select the value file manually.I do not want to do this beca...

I have some Jobs in Develoment environment which is having various Job parameters(Database username,Database password etc) defined in one parameter set.These Job parameters are different from Development ,Test and production environment.How to make sure that no changes should be done to the Datastag...