This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
@murphy-brian ,
The ELT DML snaps (namely the LOAD, INSERT-SELECT, MERGE INTO, SCD2, EXECUTE) were intentionally designed to not execute in Validation mode (Design mode) for the following reasons:
These snaps can inadvertently corrupt or make the dat...
Hello @GBekkanti,
It is not the issue with the input data. It is the issue with where the input data is coming from. That is why I mentioned the problem could be either the file reader snap or any other snap that is used for reading the input data an...
Hello @Ajay_Chawda,
Your initial use case is different from the current use case that you sent me later. In the latest use case that you sent out there is no need to switch columns to rows. Hence there is no need to use UNION etc.
I have attached the...
