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

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

Tell me about MD5 functions in informatica

0 Answers  

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

Define sessions in informatica etl?

0 Answers  

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

Different sorts of metadata that stores in the storage facility?

0 Answers  

how to load rows into fact table in data warehouse

0 Answers   Informatica,

What are parallel querys and query hints?

1 Answers  

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories