DSXchange

Hi, If you specify the where clause it willl only return those rows that satisfy the condition specified in the where clause. It will not return all the rows. You can try the UNION Operation Select * from EMP where EMP_ID=1001 UNION Select * from EMP Can you kindly elaborate more on your requirement...

Congratulations

Hi, I have achieved your requirement in the following way Job Design: InputFile----->TransformerA----->InterMediateFile------->TransformerB----->OutputFile InputFile: I am reading the input data in a Single Column say Field1 TransformerA Declaring 2 stage variables in TransformerA StageVar =Count(DS...

Hi vijayindukuri,

viewtopic.php?t=84590
contains a FUNCTION GetParameterFromFile(ConfigFileName, ParamName) written by Tonystark. I have checked it, works great!

Hope this helps

StringToTimestamp(DSLink3.DateField:' ':DSLink3.TimeField,"%dd-%mm-%yyyy %hh:%nn")

Hi All, I found the following info on http://www-03.ibm.com/certify/certs/iisdwsdev75.shtml Approximate # of questions: 79 Duration in minutes: 105 Required Passing Score: 75 Does this mean that we have to get 75 questions right out of 79 :shock: or we should score 75% to pass the test :roll:

Hi nkreddy,

Search on SCD will give you tons of information.

This link will get you started

Cost of certification is $175 in countries like US and $100 in emerging markets like India.

Yes, thats nice. Will try the exam out on my next trip as its 576 GBP here in the UAE.

Hi All,

The 000-415: IBM WebSphere IIS DataStage Enterprise Edition v7.5 is listed on the prometric site.

The cost of the exam is listed as 576 GBP.

The exam is very expensive as compared to other certification exams.

Hi bharathappriyan, Your Input: Field1,Field2,Field3,Field4,Field5,Field6 1 100 111 112 113 114 2 200 211 212 213 214 3 300 311 312 313 314 4 400 411 412 413 414 5 500 511 512 513 514 6 600 611 612 613 614 Your file is messed up and you will have to correct it by getting the 4th row up to the 3rd ro...

Hi Poorna, If I understand your requirement then you want to extract a string from the input in which the location of the string to be extracted is not fixed. For this you need to know the Length of the string to be extracted and its location in the input string Declare StageVariables: StgLen :Len(E...

Hi, Try this, Date1=Iconv(InputDate1,"D-YMD[4,2,2]") Date2=Iconv(InputDate2,"D-YMD[4,2,2]") Year1 = OCONV(Date1,'DY') Year2 = OCONV(Date2,'DY') YearDifference=Year2-Year1 Month1 = OCONV(Date1,'DM') Month2 = OCONV(Date2,'DM') MonthDifference=Month2-Month1 IF MonthDifference<0 and ...

Hi Anupam,

You can write the routine and then export the routine without the source code.
Then import it, in this case the code tab will be disabled.

Hopefully this helps:)

Hi Kalyan,

Since you are working on UNIX platform you cannot read directly from excel you have to change the excel sheets to csv and then do the loading.

Also already suggested Search on keywords 'Excel' and 'UNIX' will give you tons of info.

Check this post for more info

Hi Jahnavi,

Check in the DataStage CD inside the Utilities/Unsupported folder.