DSXchange

thanks for quick response and apart from transformer with looping is it possible to achieve the same functionality with single stage?

I have a table consists of 2 columns and required o/p is input should be duplicated n times. n may be 2,3,5 Ex-if n is 2 and no of records in i/p is 3.required o/p is 6 rows(3*2) I can acheive using looping,copy+funnel stage but want to know is there any single stage in datastage which can get the r...

I can not post real data due to security issues in my project but following example will help for better understanding empid,ename,sal 1,vamsi,10 2,sam,20 3,ram,30 or ename,sal,empid vamsi,10,1 sam,20,2 ram,30,3 or empid,sal,ename 1,10,vamsi 2,20,sam 3,30,ram I want to load into a table which consis...

I have a file consists of 3 columns col1,col2,col3 and i want to load this data into a table.I am facing below problem while loading data into table. Number of columns are fixed in file but the order of columns may vary.i can expect any order in the file ex:-col1,col2,col3 col3,col2,col1 col2,col3,c...

Source is Oracle Table and target is also oracle table. Col1 is Number datatype in source table and Col1 is Float(126) datatype in Target table.One to one mapping between source and target.In Datastage job i am reading col1 as Decimal 38,10 and propagating this field till target.In some cases I am n...

Let us say i have one join stage with four inputs (Table1,Table2,Table3,Table4).Which two tables will be joined first and how datastage will decide since u mentioned Execution is pairwise.

Difference between deleting a project from Datastage Adminstrator Client and deleting the project manually which is found in below link http://publib.boulder.ibm.com/infocenter/ieduasst/imv1r0/index.jsp?topic=/com.ibm.iea.infosphere_is/infosphere_is/8.5/configuration/ManuallyDeleteDSProject/player.h...

Any difference between deleting the Job from IBM InfoSphere Information Server Manager and deleting the Job from DataStage Director?

I think both are same. We can delete the job both the ways and there is no difference between them. Please correct me if i am wrong

could anybody please help on this issue?

Source is a sequential file, reading COL1 and COL2 as Double Precision. Target is an Oracle table. Output is not what is expected. SOURCE: COL1,COL2 -10240547.950000,219892.738536 current output: COL1,COL2 -10240547.949999999,219892.73853599999 expected output: COL1,COL2 -10240547.950000,219892.7385...

I tried below command in Datastage Shell
LIST DICT DS_JOBOBJECTS

But not able to understand the meaning of following fields.Any input is really appreciated.


1)Type & FIELD NUMBER
2)FIELD DEFINATION
3)CONVERSION CODE
4)COLUMN HEADINGS

New to XML and input is really appreciated <STORELIST> <ST> <STOREID> 1 </ STOREID> <STORENAME> ABC</ STORENAME> <product> <KEY_1>1</KEY_1> <KEY_2>2</KEY_2> <product1>Fan</ product1> <product2>Light</ product2> </ product> <ST/> <ST> <STOREID> 2 </ STOREID> <STORENAME> CDE</ STORENAME> <product> <KE...

@Chullet.
NO.I am new to XML and i posted the question after going through Manual

I am using XML input stage first time.Not sure about these properties.Any body input is really appreciated 1)What is meant by Repetition element required present in Transformation setting of stage tab? 2)What is meant by Repetition element required present in Transformation setting of output tab? 3)...

I also have similar requirement but not sure what are the key columns i need to mention on XML output page.Any body input is really appreciated?