We can't use sql override or other properties when using Flat file as sou

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

Question Posted / uma_d666

3 Answers
11253 Views
I also Faced
E-Mail Answers

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