why we use source qualifier transformation?

Answer Posted / vankayalapati sankar

souce qualifies transformation we can use to reduce the perfomence tunning pupose and minimum four transformations cover in it.what are those 0ne resone two join the two table in this case we can use the joiner transfomation,secound resone filter condition applied in source filter option in source qualifier transformation in that case filter tranformation cover it.third resone distinct option we can use to dublicate records remove in that case sorter tranformation cover.fourth resone sql qerry write in sql qerry option use it.in that case lookup transformation cover

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of target designer?

610


What are the features of complex mapping?

647


What are the various types of transformation?

646


What is domain in terms of informatica?

566


How to configure mapping in informatica?

676






What are the types of schemas we have in data warehouse.

531


What is resilience time?

655


What are connected or unconnected transformations?

630


What is the difference between writing a joiner query in ANSI style and THETA style?

1922


Define pmcmd command?

624


What is a repository? And how to add it in an informatica client?

659


How can you define user defied event?

622


What is informatica powercenter repository?

715


What are the different types of olap? Give an example?

564


How to generate or load values in to the target table based on a column value using informatica etl tool.

612