Interested to Buy Any Domain ? << Click Here >> for more details...
We can't use sql override or other properties when using
Flat file as source. Then what is the use of Source
Qualifier transformation?
- 3 Answers
- 12785 Views
- I also Faced
- E-Mail Answers
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 is option by which we can run all the sessions in a batch simultaneously?
What are conformed dimensions?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
what are the settiings that u use to cofigure the joiner transformation?
How do you load only null records into target?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
how many types transformations supported by sortedinput?
What is difference between a connected look up and unconnected look up?
Teradata 
