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

Answers were Sorted based on User's Feedback



We can't use sql override or other properties when using Flat file as source. Then what is th..

Answer / 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

We can't use sql override or other properties when using Flat file as source. Then what is th..

Answer / 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

We can't use sql override or other properties when using Flat file as source. Then what is th..

Answer / 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

More Informatica Interview Questions

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  


A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,


What are the types of data warehouses?

0 Answers   Informatica,


how to declare array in plsql?

1 Answers  


What is the need of an ETL tool?

0 Answers   Informatica,


How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  


how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,


Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  


Explain 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?

0 Answers  


What are reusable transformations in how many ways we can create them?

2 Answers  


Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,


Categories