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.

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

how can u load the data in time dimension?

3 Answers  

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

What is InformaticaPowerCenter?

0 Answers   Informatica,

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers