Interested to Buy Any Domain ? << Click Here >> for more details...
We can't use sql override or other properties when using
Flat file as source. Then what is the use of Source
Qualifier transformation?
- 3 Answers
- 12614 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
What is difference between stored procedure transformation and external procedure transformation?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
Explain incremental aggregation in informatica
What is aggregate cache in aggregator transformation?
How does a sorter cache works?
What is the sequence generator transformation in informatica?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
Can u generate reports in Informatica?
Without using any transformations how u can load the data into target?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Teradata 
