Let me know if m wrong in any point Regards Raj. Profile Answers by dbseeker. Can we have a different opinion on the 4th point? We could handle this using the lookup property - "Lookup Policy on Multiple Match". To handle all the rows that the lookup returns, we need to create the lookup transformation in the mapping using - "Return All values on Multiple Match" property enabled.
Once you enable this property and create the transformation, the "Lookup Policy on Multiple Match" property will only have one option selected by default - "Use all Values".
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. It will open edit transformation property window for it. Now, again click on properties tab in Edit Transformations window, and you will see only those data that you have selected.
You can use various properties of Source Qualifier, to determine what type of source data needs to transform to target table. As data can be sorted based on a single or multiple ports, you have to give the number of ports which will be used in sorting. If you give value as 1, then only empno data will be sorted.
If you give value as 2 then on empno and ename on both columns data will be sorted. Skip to content. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic.
Data Management. Tags: Informatica. Hi can any body tell me the difference between sql transformation and lookup?
0コメント