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 / 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 target designer and target load order?
What is mapplet in informatica?
Can u generate reports in Informatica?
What is the difference between source qualifier transformations source filter to filter transformation?
Design a mapping to load a target table with the following values from the above source?
What are junk dimensions?
Explain load alternative records / rows into multiple targets - informatica
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is sequence generator transformation in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain the scenario which compels informatica server to reject files?
Which development components of informatica have the highest usage?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to Create a folder using pmrep command?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?