Answer Posted / Aditya Shakya
In SQL Server Integration Services (SSIS), you can relate tables using Data Flow Task, by adding OLE DB Source and OLE DB Destination components. You can configure the source to read from one table and the destination to write to another table, thereby relating them during the ETL (Extract, Transform, Load) process.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a scheduled job or what is a scheduled task?
What is subquery? Explain the properties of a subquery?
How efficient you are in oracle and SQL server?
Why use identity in sql server?
What is acid mean in sql server?
How do I create a trace in sql server?
How can you append an identity column to a temporary table?
Why we use the openxml clause?
Explain system functions or built-in functions? What are different types of system functions?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
what is the difference between openrowset and openquery?
How do I find query history in sql server?
What is temporary table in sql server? Why we use temp table?
What are the different SQL Server Versions you have worked on?
Equi join and non equi join is possible with sql server?