Interested to Buy Any Domain ? << Click Here >> for more details...
What is source qualifier?
- 6 Answers
- 31897 Views
- SDS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhu
The Transformation which Converts the source(relational or
flat) datatype to Informatica datatype.
So it works as an intemediator between and source and
informatica server.
Tasks performed by qualifier transformation:-
1. Join data originating from the same source database.
2. Filter records when the Informatica Server reads source
data.
3. Specify an outer join rather than the default inner join.
4. Specify sorted ports.
5. Select only distinct values from the source.
6. Create a custom query to issue a special SELECT
statement for the Informatica Server to read source data.
| Is This Answer Correct ? | 34 Yes | 9 No |
Answer / fatima
source qualifier is also a table, it acts as a
intermediator between source and target metadata and, it
also generates sql, which creating mapping in between
soucre and target metadata.
| Is This Answer Correct ? | 25 Yes | 8 No |
Answer / kumar
source qualifier is a default transformation which reads
data from relational database or flatfile.
we can read data from source
sort data
select distinct data
join data
filter the data
modify sql queries
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / naveen kumar reddy
A Source Qualifier is a data extractor to an Informatica
Service(Server) that can extract data from Objects(Tables),
Flat files or XML files into a unique readable format.
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / sandeepbabu
Represents the source record set queried by the integration server/service.It is mandatory in the mapping when the source is relational or flat files.And it is a Active transformation.
source qualifier contain some properties is given bellow:
1>Sql query:It is generated by integration server by default and It contain Sql override,used to modify the default select Statmets...
2>user defined join:It is content of WHERE Clause to join separate Source
3>source filter:Filter applied to source Records..
4>Number of sorted ports:used to sort input ports.When we are using sorted ports the Powercenter add ports by default'Orderby'.BY default sorted ports are Zero
5>Select Distinct:selct unique values only
6>pre sql:The sql database before reads the source data
7>post sql:The sql database after write the data in to target table..
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / pradeep
using sq'transformation we can driveout data from an
object,and it can drivein to the next transformation,this
is an mediator betwwen source object and to the next
transformation to get the data fom source object.
| Is This Answer Correct ? | 5 Yes | 14 No |
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the difference b/w natural key and surrogate key
what are surrogate keys?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
What are the associated ports in look up T/R.
how to get max value record into one target and remaining records into another target?
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
What is a shortcut and copy in Informatica and how two are different with each other?
What is the Rank index port in Rank transformation?
explain about unit testing? in real time?
what are 3 tech challenges/ common issues you face?
Teradata 
