We can't use sql override or other properties when using
Flat file as source. Then what is the use of Source
Qualifier transformation?
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
How do you use reject loader.
What is pmcmd command?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Difference between Data and Index Caches?
Explain informatica architecture - version 8 / 9
What are the differences between source qualifier and joiner transformation?
Define mapping and session?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How does a sorter cache works?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
what is mean by complex business rule ?
What do you mean incremental aggregation?
Performance tuning in UNIX for informatica mappings?
Whats there in global repository
What is a transaction control transformation?