What is the main data object present inbetween source and
target. I answered Mapping. Transformation etc.. But it is
not the answer. So please give me an apt answer. Thanks in
advance
Answer Posted / manohar
Answer is Source Qualifier.
Since the source may be anything so Informatica should be
able to understand the data types perfectly, so only the
data can be pass through to the target. So you can see when
drag the souce along with the source SQ will be created
automatically.
why not the other transformations?
Since other transformations are not capable of wat the SQ
transformation has.
Correct me if i am wrong
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Mention few advantages of router transformation over filter transformation.
Explain about Informatica server process that how it works relates to mapping variables?
What is the different lookup cache(s)?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What differs when we choose the sorted input for aggregator transformation?
How will the document be delivered to me?
what is the hint? how to use it to reduce the query processing in program?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Differentiate between router and filter transformation?
What is standalone command task?
Enlist the various types of transformations.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?