WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER?


chandumba2005@gmai.com

Answer Posted / srinivasulu raju

It is a Process of Defining the User Defined SQL Query: "to
filter the data,Join the Data, Sorting the data,
eliminating Duplicates...

Condition: Source must be DataBase.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you load alternate records into different tables through mapping flow?

1305


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

816


What is different between the data warehouse and data mart?

639


What is an unconnected transformation?

674


what is the Default Source Option For Update Strategy Transformation?

768






What does reusable transformation mean?

681


What all join we can perform in LOOKUP transformation?

574


Have you worked with/created Parameter file

1234


How can you generate reports in informatica?

590


What is the surrogate key?

649


What are the tasks that source qualifier perform?

639


What is the difference between router and filter?

654


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

639


can you please explain me pre session and post session options?

6399


Global and Local shortcuts. Advantages.

1474