One Star

TIS Load balancing documentation

Hello,
Is there any documentation explaning how Talend Integration suite (4.2) load balaing is working?
I'm looking mainly for Active/Active Configuration....
Regards;
David
5 REPLIES
Community Manager

Re: TIS Load balancing documentation

Hi David
I suggest you to read the corresponding document section on TalendAdministrationCenter_xxx_UG_xxx_EN.pdf 3.2 Managing virtual servers and their assignments and have a look at this topic:
http://www.talendforge.org/forum/viewtopic.php?id=15512
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: TIS Load balancing documentation

My input is Excel file (attached)
The Expected Output is to load the values into temp table (SQL SERVER).
I am attaching the Excel file, the values in the first column "CPT" and the values in the second cloumn ICDCOVERED , I need to load these values.

The first cloumn and the second cloumn have 1 to many relationship,
Problem 1:
In the Excel file when does not a value in the first column, that it show continue to load the data until it comes across the next value.

Problem 2:
In the second column (ICDCOVERED), some cell values are individual values like
(003.1), some cells have multiple values like (606.02, 607.01) and some cells have values ranges for example: (503.02-503.09).


My objective is to load the data one value in each row of the temp table, when it is multiple values in the cloumn it should load values into seperate records, and when it is a range it should query the range from the database table get the range of values and load the values into seperate records in the Temp Table, this is regarding the ICDCOVERED colum of the Excel file.

Now for the CPT column of the Excel file it should maitain the 1-many relationship
while loading the data.

Hope I am clear now.

I am really not able undersatnd the way I can accomplish this.

Sorry I am not able to pose this question on the forum, I am confused where I have to type
my question in the forum.

Please I would appreciate if you can reply back to this e-mail address.

Ali
One Star

Re: TIS Load balancing documentation

CPT ICDCOVERED
87088 003.1
038.0,038.10-038.11,038.19,038.2,038.3,038.40-038.44,038.49,038.8,038.9
276.2
276.4
286.6

My input is Excel file (attached)
The Expected Output is to load the values into temp table (SQL SERVER).
I am attaching the Excel file, the values in the first column "CPT" and the values in the second cloumn ICDCOVERED , I need to load these values.

The first cloumn and the second cloumn have 1 to many relationship,
Problem 1:
In the Excel file when does not a value in the first column, that it show continue to load the data until it comes across the next value.

Problem 2:
In the second column (ICDCOVERED), some cell values are individual values like
(003.1), some cells have multiple values like (606.02, 607.01) and some cells have values ranges for example: (503.02-503.09).

My objective is to load the data one value in each row of the temp table, when it is multiple values in the cloumn it should load values into seperate records, and when it is a range it should query the range from the database table get the range of values and load the values into seperate records in the Temp Table, this is regarding the ICDCOVERED colum of the Excel file.

Now for the CPT column of the Excel file it should maitain the 1-many relationship
while loading the data.

Hope I am clear now.

I am really not able undersatnd the way I can accomplish this.

Sorry I am not able to pose this question on the forum, I am confused where I have to type
my question in the forum.

Please I would appreciate if you can reply back to this e-mail address.

Ali
Community Manager

Re: TIS Load balancing documentation

Hi
For better management, please report a new topic if your problem is not related to this one.
Thanks for your support!
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: TIS Load balancing documentation

My input is Excel file --
CPT ICDCOVERED
87088 003.1 -- some cells have only single values
038.0,038.10-038.11,038.19,038.2,038.3,038.40-038.44,038.49,038.8,038.9 -- some cells have both comma seperated as well as ranges
276.2, 278.1 -- some values are comma seperated
276.4 - 276.9 --some values are ranges separeted by ' - '
286.6
88037 034.02, 103.04 -- when there is comma beween the values it should load the values in seperate cells.
023.01, 123.03
201.01-201.04 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell with its corresponding values of CPT (fisrt column)
Excepted Output Excel file---
CPT ICDCOVERED
87088 003.1
87088 038.0
87088 38.10-038.110 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
87088 038.19
87088 038.2
87088 038.3
87088 038.40-038.44 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
87088 038.49
87088 038.8
87088 038.9
87088 276.2
87088 278.1
87088 276.4
87088 286.6
88037 034.02
88037 103.04
88037 023.01
88037 123.03
88037 201.01-201.04 -- when there is range it should connect to the DB(SQL SERVER) get the range of values and load them seperately in each cell
I need to organize the Excel before I am using a ELT tool to load the values from Excel to SQL SERVER, but first I need to organize the Excel values so that it can be loaded properly.
I am also attaching the Excel sample file.
Thanks , I would really appreciate your help.
Ali