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 / sripal
While loading into Target, Integration Service start reading the source data from Source qualifier irrespective of Relational/Flat Sorce files.
I guess I hit your question.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
What are batches?
can we override a native sql query within informatica? Where do we do it? How do we do it?
how many types of dimensions are available in informatica?
What is intricate mapping?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How would you copy the content of one repository to another repository?
How do you change a non-reusable transformation to reusable transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is target load order?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the new features of informatica 9.x at the developer level?
How to delete duplicate row using informatica?
What is the difference between Active and Passive transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?