DSXchange

Hi All, My source column QT_Travel data type is TimeStamp and data is like I mentioned below. Nov 11 1996 12:00AM I have to split this data into two columns with date and time as a separate column into target table. Expected Output: Date Column-1996-11-09 Time Column-12:00:00 I have Used TimeStamp t...

Hi All, My Source is ODBC database and my reference and target table is DB2. In source and reference table have a column like SITE_DESC datatype is a varchar. I have verified the data seperately in each database. Identified some common records between tehm. But When I was doing a inner join based on...

Really Thanks! Your solution works as per the expected output.

Once again thanks for your help at the right time. :D

Hi All, In my Source table has start date and end date and data's are like I mentioned below Start Date End Date 08-11-2012 13-11-2012 Expected result would be 08-11-2012 09-11-2012 10-11-2012 11-11-2012 12-11-2012 13-11-2012 I have to pivot the start date till the end date. I know this logic would ...

Hi All, My job is a simple direct load. I am extracting the records from the source file and trying to load the data into the db2 connector stage. But job got aborted due to below mentioned error. "The connector could not establish a connection to DB2 database TIS_STGD using user "Ax_etl.&...

I fixed this problem. :D

Hi All, I am facing one issue regarding the @ITERATION. In one of my job I used function like this @ITERATION <=STAGVAR. The STAGVAR value I have specified as 7. so that @ITERATION should execute upto 7 times. but when I run the job, my job aborted due to below mentioned warning. "The warning t...

Hi All,

I need one information. Is it possible to take the backup of Entire repsoitory? If yes, can we able to replace that repository into new environment server?

Thanks to everyone. I fixed my problem.

Once again thx for your tremendous support :D

Thanks for your reply aarlett. Could you please bit explain the logic ?

Hi All, One of my source file column value like I mentioned below Column1 ---------- 8,12-14 10,2-7 If there is any range in the column I need to load the data sequentialy in beow mentioned format with proper delimiter. Column1 ---------- 8,12,13,14 10,2,3,4,5,6,7 Any help is really appreciated..

I fixed my problem. Thanks to everyone :D

Thanks for your reply. I have done some changes in my code. Now, I am able to pick all my 16 tables. But still my job aborted. I got message like this SQL statement failed: SELECT UNQID, END_DT from M3DEV6_EDW. where END_DT<>to_date('9999-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS'). It seems like tryi...

Hi All, I have a file which consists more than 16 table names. I need to call all the table one by one through start loop Activity. After that I need to do a insert and update for all the 16 tables. My job is running fine till my 15th table but I am not able to pick 16 table. All tables names are de...

Thanks to everyone. I resolved my problem. :D

Is there any way to write this concept in routine? If yes, how can I do that?