Interested to Buy Any Domain ? << Click Here >> for more details...
We can't use sql override or other properties when using
Flat file as source. Then what is the use of Source
Qualifier transformation?
- 3 Answers
- 12752 Views
- I also Faced
- E-Mail Answers
Answer Posted / mahesh
override option will work only on relational database for that
purpose we source qualifier will not use on flat files.
whenever u write a query in source qualifier it will goes
directly to that data base and execute the query n send the
result set to the informatica level. in flat files there is no
there is no database servers for flat files.
Hope u r understand now
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is option by which we can run all the sessions in a batch simultaneously?
What are the types of schemas we have in data warehouse.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is an expression transformation in informatica?
explan ur project architecture?
Why is sorter an active transformation?
What is update strategy transform?
What is joiner transformation in informatica?
Define pmcmd command?
How to generate sequence numbers using expression transformation?
Explain what are the different versions of informatica?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the components of Informatica? And what is the purpose of each?
what is the Default Source Option For Update Strategy Transformation?
