Recent questions tagged etl

0 votes

724 views

1 answer

etl - Buffer length vs column precision vs DTM buffer size in Informatica

I have a workflow which loads millions of data from flat file to Oracle Table. The buffer length set was ... buffer-length-vs-column-precision-vs-dtm-buffer-size-in-informatica...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

465 views

1 answer

etl - When do we consider snowflaking a star schema?

In the below dimensional model, all the dimension table follows the star schema except the prod table, which is ... questions/65875735/when-do-we-consider-snowflaking-a-star-schema...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

485 views

1 answer

etl - Data warehouse modelling

Closed. This question is opinion-based. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65883718/data-warehouse-modelling...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

565 views

1 answer

etl - talend data insertion with auto increment keys

I am using talend studio free version. I have an excel with 2 sheets "System" and "Part" table ... .com/questions/65517637/talend-data-insertion-with-auto-increment-keys...

asked Oct 7, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

616 views

1 answer

etl - SSIS Generating .tmp Files in Checkpoint Directory

I'm noticing our SSIS packages that are utilizing Check Points have started to create .tmp files in our ... com/questions/66048954/ssis-generating-tmp-files-in-checkpoint-directory...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

669 views

1 answer

etl - Data aggregation during data load to snowflake using snowpipe

I am evaluating snowflake for reporting usecase. I am considering snowpipe for ETL. Data is ingested from ... Is this the correct approach for implementing complex tranformations?...

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

598 views

1 answer

etl - talend data insertion with auto increment keys

I am using talend studio free version. I have an excel with 2 sheets "System" and "Part" table data. I want to ... the ids in talend and insert into a new table(system_to_part)?...

asked Feb 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

616 views

1 answer

etl - linq2db - server side bulkcopy

I'm trying to do a "database side" bulk copy (i.e. SELECT INTO/INSERT INTO) using linq2db. However, my code is ... C# to SQL transpiler but it is also trying to move data around....

asked Jan 27, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags