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 |
How you can differentiate between connected lookup and unconnected lookup?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
What are the types of data warehouses?
how to declare array in plsql?
What is the need of an ETL tool?
How do you load unique records into one target table and duplicate records into a different target table?
how do u use sequence created in oracle in informatica? Explain with an simple example
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are reusable transformations in how many ways we can create them?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V