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 / 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 |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
What are the advantages of informatica?
What is a joiner transformation?
What is rank transformation in informatica
where to store informatica rejected data? How to extract the informatica rejected data?
Define update strategy?
What is a code page?
What is standalone command task?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What does refresh system mean, and what are its distinctive choice?
How to create a non-reusable instance of reusable transformations?
Reusable transformation and shortcut differences
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to open an older version of an object in the workspace?
Explain Dataware house architecture .how data flow from intial to end?