DSXchange

Thanks Ray.
Issue has been resolved. It was posted by me before I go to sleep to get other inputs on early hours. I have a plan to inculde it once I get free onto the post for others reference.

Thanks Ray! I appreciate your comments. See Ray some times we dont really get spending too much time on conversions. So we post into the forums and share with the others experience. It doesnt mean not coded or not able to hanle it. Any developer can code based on their logic but some persons it may ...

Thanks for the idea Ray!
But I am not getting the function to subtract from the date.

Hi All, I am trying to add hours to timestamp in the transformer, add hours will come from derived field. My option is code in transformer only. My code is working when am adding hours(positive SHours). But not working subtracting hours (negative SHours). Getting correct time part but not the date. ...

FastTrack uses a five-part fully qualified name containing the host name, data source, data store, data schema, table name. Search DSXchange for more information - this has been addressed within the ... Ray, I have defined in correct format hostname.datasource.schema.table.columnname and addressed ...

Sorry Guys if I posted in wrong forum. This request for using with fasttrack application to import csv file and generate datastage job. Concatinating of the two fields from same source working fine but need to concatenate two diffent sources of the columns say like Table1.Name:Table2.Name. Is there ...

Hi All, I could able to concatenate two fields which is coming from the same source without using table qualifier but not able concatenate with two table columns. Please share with me if you have any solutions. Example: Fields Table.SName,Table.HName working with the solution SName:HName. Would requ...

Generated csv file differs on Source and Target Business Term columns with the metadata. It was resolved after identifying that and defined correctly.
Thank you for the ideas.

Terms are not matching at Data Source with Specification document.

Thanks,
Kali.

jpraveen wrote:Hi

i am running on 2-node processor
and i made the target as HASH partitioning and the job finished successful

Thanks to all

What database you are using? If it is teradata add, LOCKING ROW FOR ACCESS for all selected queries then you wont be locked your self.

Thanks,
Kali.

Then I am still not understanding the problem. There are only two choices. A source/target column in FastTrack either (a) matches the full 5 part name of already imported metadata shared tables or (b) it does not. Ernie I have tried two other options but failed: 1. Changed table names with other na...

I don't know what else to tell you....look in the tree of database tables that you have in FastTrack.... You will see a 5 part name for each column.... host.database.schema.table.column If you fully qualify these names in your csv file being imported, then they will match....check spelling, upper/l...

Thanks Ernie!
But still I have no luck using Fasttrack to fix it. Also I tried different scenario's too and issue still the same. I am missing one small step which I couldnt able to identify.
I have no problem with new table and columns with new mapping csv file with new host.

Thanks,
Kali.

eostic wrote:Ok...then be sure and import those target tables and their columns as Shared Tables prior to importing any .csv mappings into FastTrack.

Ernie

Thanks Ernie!
Could you guide me how to make columns as Shared Table.

Thanks,
Kali.

If the source/target names were in your original spreadsheet, check their spelling and case carefully......it should match, assuming that you already have those hosts and tables as formal Shared Tables. Ernie Thanks Ernie! I have spcified source and target in correct way and also source and targets...