Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Extend stage table generation to enforcre and use traget same target column type #280

Open
6 tasks
mattywausb opened this issue May 13, 2024 · 0 comments
Open
6 tasks
Labels
1 concept Extention or change of dvpd concept 1 dvdp Syntax addition or change in syntax of dvpd 1 mod DVPDC DVPDC change 2 Test Testcase creation 3 mod DDL
Milestone

Comments

@mattywausb
Copy link
Collaborator

mattywausb commented May 13, 2024

Since a good practice woul be, to do all type conversions from source to stage, the stage table must use the target column types in its own columns.
This can result in two different behaviours.

  1. raise an error, when not all mapped target columns for a stage column have the same type
  2. create multiple stage columns for every target type needed

since teh 2nd is very rare, we will implement the 1st first.

  • concept documentation adapted
  • function tests added
  • check tests added
  • Model profile syntax extended with "use_target_type_in_stage"
  • dvpdc extended
  • decided if we will put method 2. on our feature list
@mattywausb mattywausb added 1 concept Extention or change of dvpd concept 1 mod DVPDC DVPDC change 2 Test Testcase creation 1 dvdp Syntax addition or change in syntax of dvpd 3 mod DDL labels May 13, 2024
@mattywausb mattywausb added this to the Release 0.6.2 milestone May 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
1 concept Extention or change of dvpd concept 1 dvdp Syntax addition or change in syntax of dvpd 1 mod DVPDC DVPDC change 2 Test Testcase creation 3 mod DDL
Projects
None yet
Development

No branches or pull requests

1 participant