Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

What is a mapplet/worklet in informatica?

0 Answers  

How would you copy the content of one repository to another repository?

0 Answers  

what are the types of facts with Examples?

3 Answers  

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

What is dimensional table?

0 Answers  

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

For more Informatica Interview Questions Click Here
Categories