Answer Posted / 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 |
Post New Answer View All Answers
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are mapplets?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is depict expression change?
How do you load only null records into target?
Write the unconnected lookup syntax?
Enlist the tasks for which source qualifier transformation is used.
what is the size of your data warehousing?
Differentiate between Load Manager and DTM?
How will the document be delivered to me?
Explain direct and indirect flat file loading (source file type) - informatica
What are batches?
What is data movement mode in Informatica and difference between them?
What is aggregate cache in aggregator transformation?