What are the tasks that source qualifier performs?



What are the tasks that source qualifier performs?..

Answer / swetha

Join data originating from same source data base.

Filter records when the informatica server reads source data.

Specify an outer join rather than the default inner join

specify sorted records.

Select only distinct values from the source.

Creating custom query to issue a special SELECT statement
for the informatica server to read source data.

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More Informatica Interview Questions

How to display null values on a target & non-null values on a target?

3 Answers  


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  


Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,


What is meta data and system catalog?

2 Answers  


1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,






hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  


How do you implement scheduling in Informatica?

1 Answers  


Write the prerequisite tasks to achieve the session partition?

0 Answers  


What are the reusable transforamtions?

1 Answers  


What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,


What is informatica?

0 Answers  


Explain the types of lookup transformation?

0 Answers  


Categories