mohit
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Loading huge volume of data into Target Systems
Hi, I want to load a huge amount of data from Snowflake to SQL server and I want to load it in batches, so that it will not fail because of any SnapLogic memory issue or resource issue. Also I don’t want to use script snap. Does any one has such kind of sample pipeline? @dmiller @skatpally ThanksRe: String data, right truncation Error while loading data from Snowflake to SQLserver
Hi @fmdf I resolved the issue by increasing the length of column in table. It is saying “Column 9”, then you just have to go and get the ddl of table and check which column is there at 9th position and then increase the length of column. In my case I was facing this issue bcoz snowflake handles both Unicode and non Unicode characters with Varchar but in sql server for Unicode you have to give nvarchar. So lets say if you have column length is varchar(100) in snowflake then you have to give nvarchar(100) or more than that. Please try this if it helps.3.3KViews0likes0CommentsRe: Parse Excel file with duplicate columns
Hi @ igormicev Thanks for the reply but I don’t want to remove the Duplicate columns. What I want to do is below 🙂 Lets say I have two duplicate columns Address, Address. So I want to take both the columns insert the data into database but with new name like Address and Address1. And I don’t want to do this manually by giving the name individually in mapper. Can you suggest something. Thanks Mohit Yadav3.1KViews0likes1CommentWant to add NEW LINE CHARACTER in mapper
I am trying to add new line character between three of my contents but it is not allowing me. Can anyone tell how new line character can be used in Mapper. Below is my mapper expression. $Address+ \n +$Name+ \n+$Age I want an output like below. Address Name Age Can anyone suggest something. Thanks in advance6.4KViews0likes7Comments