DSXchange

AhmedSamir

Finance team need this sheets

AhmedSamir

HI there,

Am tring to load 2,000,000 records to excel sheet, as we know the maximum records accepted per sheet is 1,000,000 as a consequnce i need to divide the records to two tabs.

how to solve this case ??

AhmedSamir

thx .. but there is no stage for doing this case ..

AhmedSamir

thank you ShaneMuir

1- just want them split equally

2- just split only

AhmedSamir

Hi there,

i have some development idea's fro datastae designer, what is the channel that i corspond to send them the idea's .

thank you

AhmedSamir

hi there, I want to divide the records volum to be divide to the links ex : sequ_file 15 record ----- > ????? which stage ------- > Link 1 5 record ------- > Link 2 5 record ------- > Link 3 5 record thank you

AhmedSamir

Dear chulett,

thank you for reply,

about the index :

Code: Select all

PRIMARY INDEX ( Subscription_Id )
PARTITION BY ( RANGE_N(Call_Start_year  BETWEEN 2008  AND 2020  EACH 1 ),
RANGE_N(Call_Start_Month  BETWEEN 1  AND 12  EACH 1 ) );

yea, it's aggregation table and

AhmedSamir

I found a solution but i need more ideas : We will build large loop having two parameters "YEAR"-"MONTH" inside it another loop using the two parameters on fixed uning column: Call_start_Hour BYTEINT COMPRESS (0 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,19 ,...

AhmedSamir

Dears, Am trying to migrate aggregation table with this structure : Subscription_Id INTEGER, Call_Start_Month BYTEINT, Call_Start_Year SMALLINT, Call_start_Hour BYTEINT COMPRESS (0 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17 ,18 ,19 ,20 ,21 ,22 ,23 ), Rate_Plan_Product_Id INTEGER COMP...

AhmedSamir

hi there I need to create table and let the job load data on it, it's working with me under this conditions : 1- Teradata connector - Access method : immediate - Before SQL : create statement - APPEND but in my case when u change to BULK load the error raise on the WORKTABLE for the BULK ERR: Terada...

DSXchange

Search found 10 matches

Write to multiple excel tabs ?

channel for development idea's ?

Divide records to links

How to divide 5B Rows to avoid "Session logged off"

Create table Before load ?