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
- 12577 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Why update strategy and union transformations are active? Explain with examples.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is a pre-defined event and user-defined event?
What are the guidelines to be followed while using union transformation?
To import the flat file definition into the designer where should the flat file be placed?
How we can use union transformation?
Explain how many types of dimensions are available in informatica?
Could you explain what is enterprise data warehouse?
can we override a native sql query within informatica? How do we do it?
What is the surrogate key?
What is dynamic cache?
What is an unconnected transformation?
Can we create two repositories on same database instance in oracle?
