can u explain one critical mapping?
performance issue which one is better? whether connected lookup tranformation or unconnected one?
Submitted by: AdministratorIt depends on your data and the type of operation your doing.
If you need to calculate a value for all the rows or for the maximum rows coming out of the source then go for a connected lookup.Or,if it is not so then go for unconnectd lookup.Specially in conditional case like,we have to get value for a field 'customer' from order tabel or from customer_data table,on the basis of following rule:
If customer_name is null then ,customer=customer_data.ustomer_Id
otherwise
customer=order.customer_name.
So in this case we will go for unconnected lookup
Submitted by: Administrator
If you need to calculate a value for all the rows or for the maximum rows coming out of the source then go for a connected lookup.Or,if it is not so then go for unconnectd lookup.Specially in conditional case like,we have to get value for a field 'customer' from order tabel or from customer_data table,on the basis of following rule:
If customer_name is null then ,customer=customer_data.ustomer_Id
otherwise
customer=order.customer_name.
So in this case we will go for unconnected lookup
Submitted by: Administrator
Read Online ASP.NET 2.0 Job Interview Questions And Answers
Top ASP.NET 2.0 Questions
☺ | Web service support |
☺ | What types of data validation events are commonly seen in the client-side form validation? |
☺ | In A Page I have gridview with Options of select and delete using hyperlink when i am selecting any one of then it has to open another page how can it? |
☺ | How to rename a table using sql queries? |
☺ | Can a .NET web application consume Java web service? |
Top Dot Net Technologies Categories
☺ | MSF Interview Questions. |
☺ | .Net Architecture Interview Questions. |
☺ | ASP.Net MVC Interview Questions. |
☺ | Entity Framework Interview Questions. |
☺ | C# (Sharp) Programming Language Interview Questions. |