You are designing a SQL Server Integration Services(SSIS) data flow to load sales transactions from asource
system into a data warehouse hosted on SQL Azure. One of the columns in the data source is named
ProductCode. Some of the data to be loaded will reference products that need special processing logic in the
data flow. You need to enable separate processing streams for a subset of rows based on the source product
code. Which data flow transformation should you use?
A.
Source Assistant
B.
Audit
C.
Destination Assistant
D.
Script Component
Explanation:
According to these references, this answer looks correct.
Reference: http://msdn.microsoft.com/en-us/library/ms137640.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms141150.aspx
Reference: http://msdn.microsoft.com/en-us/library/ff929138.aspx
Reference: http://msdn.microsoft.com/en-us/library/ff929116.aspx
It could also be option A.) ‘Source assistant’. Ii could be used a second ‘Source assistant’ to fetch only the products that need a special processing logic…
Or am I missing anything in the question?
0
0
Good post!
http://www.easyimmigrations.com/consultation-process-singapore-pr/
0
0
Thanks
http://www.immigrations.com.sg/consultation-process/
0
0
Beautiful information for me
I am manager of Eight Design Pte Ltd.
Eight Design is the best interior design company.
0
0
Nice blog
Deep Mould Co. Ltd is top plastic component company.
0
0
For valuable information for me
Thank you so much
I am Peter Foo. My company is Neumart Technology. It is Singapore Company. We offer solenoid valves, Air filter, Drain Timer Valves, Relief Valve etc.
0
0
Quite good this Article.
I am the manager of the Offix Pte Ltd
This is best office renovation company in Singapore
0
0