We can't use sql override or other properties when using
Flat file as source. Then what is the use of Source
Qualifier transformation?

Answer Posted / snjsngh15

So in this situation we used the source qualifier transformations to convert the external datatype to informatica native datatype and by default source qualifier transformations is created if our source is a flat or relational tables and also one property is tracing level

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the tasks that source qualifier perform?

629


What is powercenter on grid?

689


how to load rows into fact table in data warehouse

637


What are the components of Informatica? And what is the purpose of each?

614


waht type of interface is used for testing the data in informatica

1828






What is the difference between a repository server and a powerhouse?

801


What is meant by a domain?

623


While migrating the data from one environment to another environment how would you manage the connections?

623


What is fact table? Explain the different kinds of facts.

610


Design a mapping to load the cumulative sum of salaries of employees into target table?

889


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1457


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

597


What are the different types of repositories created using informatica?

653


What is meant by LDAP users?

687


What are the new features of informatica 9.x at the developer level?

600