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
- 12925 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
What is the sql query overwrite in source qualifier in informatica
What is source qualifier transformation in informatica?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
To import the flat file definition into the designer where should the flat file be placed?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
what is song in infrmatica...?
wat are deployement groups in informatica, how it will be used for developers
In development project what is the process to follow for an etl developer from day1
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is a mapplet/worklet in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are the uses of etl tools?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the difference between Active and Passive transformation?
Mention few power centre client applications with their basic purpose?
