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.

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.

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

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.

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..

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.

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

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?

0 Answers  

What are active transformations.

0 Answers  

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

what is workflow varible

1 Answers   HP,

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

What are the challenges of Dataware housing in the future?

2 Answers   HP,

What is aggregate awareness?

1 Answers  

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

Briefly describe lookup transformation?

0 Answers  

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers