We can't use sql override or other properties when using
Flat file as source. Then what is the use of Source
Qualifier transformation?
Answers were Sorted based on User's Feedback
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 |
Answer / sripal
While loading into Target, Integration Service start reading the source data from Source qualifier irrespective of Relational/Flat Sorce files.
I guess I hit your question.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
What the difference is between a database, a data warehouse and a data mart?
What are the options in the target session of update strategy transsformatioin?
What is difference between a connected look up and unconnected look up?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
whether Sequence generater T/r uses Caches? then what type of Cache it is
How do you change parameter when you move it from development to production.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override
what is the look up transformation?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
What are Dimensions and various types of Dimensions?
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com