Yes, you can. But we recommend you avoid doing it. Here's why:
- There is no guarantee that both your chosen data sources have similar data structures. If you ingest data from both sources with different structures, you'll end up with a table that merges them.
If one source has 5 columns, and the other with 3, your table will end up with 8 columns. Null values are provided for those records that don't have values for the columns brought about by the merge. As a result, you'll have a table with a confusing structure. - There's a likelihood that both data sources might have the same primary key, regardless of whether their data structures are similar or not. Records with the same primary key value will simply overwrite each other, with the last sequential record prevailing. Because of the overwriting, you'll end up with fewer records than expected.
Comments
0 comments
Please sign in to leave a comment.