why we use source qualifier transformation?
Answer Posted / pooja amhed
hi,
we use SQ trans as 1st trans due to its properties. in SQ
trans i means at the begin of extracting of data its self
we can remove duplicate ,we can filter,join,override the
query,pre and post sql querey.... in orther words we use it
to impore the performance.
Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the static cache and dynamic cache in informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
how to create user defined function (udf) in informatica
how to load rows into fact table in data warehouse
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are pre and post-session shell commands?
How to extract sap data using informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain the informatica workflow?
Explain how to import oracle sequence into informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?