in this same method, can i use source as oracle and sink as sql, however the schemaname is doesnt match but the tablename matches. while using the above method. The inner activity is failing via split condition
Hi sir, i have set up Integration runtimes & its running as well but when i try to connect to my local database using create new source dataset it is not showing all the tables in my local db rather shows only system tables. Could you pls help me in that.For further clarifications we can connect & you can help me if possible
hello Sir , Can we insert only top 1000 rows for these multiple tables. ? Your response would be very helpful.
To insert top 1000 rows you will have to use SQL query with top clause
Awesome explanation and good scenario ❤
Glad to know. Thank you for watching
Sir ,, sink why do use another parameter same parameter also will work ?
Very nice video. Very informative.
Glad you liked it
in this same method, can i use source as oracle and sink as sql, however the schemaname is doesnt match but the tablename matches. while using the above method. The inner activity is failing via split condition
Hi sir, i have set up Integration runtimes & its running as well but when i try to connect to my local database using create new source dataset it is not showing all the tables in my local db rather shows only system tables. Could you pls help me in that.For further clarifications we can connect & you can help me if possible
Thanks for posting it
Welcome
What if we have more than 5000 tables? At that time Lookup activity won't work. What should we use at that time?
do have any solution for your question...
In lookup activity we need to connect to local server or azure sql server
Local one source
u should have made from the beginning and go into deep pls