DSXchange

Thanks for the Response .
But the list of jobs are huge . And again searching within the exported XML is a cumbersome process .
Is there any other alternative ?

Is there any way to find out ; all the datastage jobs where a particular parameter from a Parameter set is used ?

I have an urgent requirement where i have to split a record based on the value present in one column called 'Quantity'. e.g Input --------- col1 Quantity Price ---- -------- ----- 1 2 p1 2 5 p2 Output -------- col1 Quantity Price ---- -------- ----- 1 1 p1/2 1 1 p1/2 2 1 p2/5 2 1 p2/5 2 1 p2/5 2 1 p...

Ya , that could be done .. but all the columns in source are of varchar type so ..it smoothly getting transferred to the output . Anyways .. i can handle that partcular header record in the transformer but i wanted to know is not there any option available in sequential file stage itself like the Fi...

@ nani0907 Yes it worked .But the "Filter" option is not available if the Read Method is "File Pattern" and not "Specific File(s)" . In my case , the number of files are varying ...so i have to use "File Pattern" only to read multiple files. So, what needs to ...

Hi everyone , I am using a sequential file stage . and reading multiple files with Read Method set as "File Pattern" . The problem which i'm facing is .....all files are having header in it , although i'm specifying "First Line is Column Name" to TRUE ..... the header is also get...

Yes , because the default analysis database IADB for IIS is DB2 and we need to explicitly mention its codepage .

Hi ray ,
Thanks for your effort .

We got the solution .

We need to add the following two parameters in the DataStage Administrator :

1.NLS_LANG and set its value to AMERICAN_AMERICA.UTF8
2.DB2CODEPAGE and set its value to 1208

My apologies ... Let me try to clear it to you : The source oracle table has the Japanese data correctly populated . But when we are importing that meta-data in the IA Repository considering as its source ; its not importing those data correctly and converting it to charset=windows-1252 . Although t...

Ray , I'm afraid i cud not get you what exactly you want to say .... The Datastage job which populated that oracle table from source file has all encoding done correctly . So , the data in the oracle table are stored correctly and we are able to read the Japanese data properly in the table. Now For ...

Hi ray ,

Do i need to set the code page for Japanese character while loading the data to Oracle Table ?

OR

Do i need to set the NLS for Japanese character in the IIS Administrator ?Earlier it was set to UTF-8.

Please clarify me.

Hi , I am trying to do a column analysis on a column which is having Japanese character in it . But it is not able to profile those data and giving a warning like : pxbridge: [IIS-CONN-DAAPI-000067] Schema reconciliation detected a size mismatch for field SUPNM. When moving data from source field ty...

Thanks for ur response . the Sql really helped me in gettin the thing

can anybody explain me the role playing dimension with real 2-3 examples ?????