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
What are the tasks that source qualifier perform?
What is powercenter on grid?
how to load rows into fact table in data warehouse
What are the components of Informatica? And what is the purpose of each?
waht type of interface is used for testing the data in informatica
What is the difference between a repository server and a powerhouse?
What is meant by a domain?
While migrating the data from one environment to another environment how would you manage the connections?
What is fact table? Explain the different kinds of facts.
Design a mapping to load the cumulative sum of salaries of employees into target table?
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?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the different types of repositories created using informatica?
What is meant by LDAP users?
What are the new features of informatica 9.x at the developer level?