DSXchange

This is simple use Transformer stage and map the columns to two output likns as how you need data in the output....

For reading Excel files one stage is there i.e. Java client stage this stage is not included in the Datastage your company need to buy this stage from IBM...

Use field function to remove <> in the column...

Its nothing but 1 dollor for that particular column i think this is fixed value for that particular column... There is no other mean for 1$...

Hi Hari how are you man this is venu from Pune... Here is your solution: Metadata specified does not match to the given file layout. Check for TRIP_NAME_IDENTIFIER, for which it is complaining about. What is the data type that been specified? If you cannot nail down, change it to varchar and view th...

Hi Sreeni see the correct null handling function try this :

If IsNull(Read_1.BEHAVIOUR_ID) Then "-1" Else Read_1.BEHAVIOUR_ID

It should be work try this and let me know...

It is simple Tony drawtime between 00.01 to 11.59 is AM and 12.00 to 24.00 is PM

Hi use transformer in that use stage variable and then you can find the first character in the date column is "0" then trim the column else pass the column as it is.... Hope this will help....

Hi All, I have source like... EmpName EmpNo Sal venu 123 10000 raju 213 20000 venkat 423 30000 O/p i want like this... EmpName EmpNo Sal venu 123 10000 raju 213 20000 venkat 423 30000 venu 123 10000 raju 213 20000 venkat 423 30000 How can i get duplicate records in target... Some times i need to pop...