Interested to Buy Any Domain ? << Click Here >> for more details...
why we use source qualifier transformation?
- 16 Answers
- 46571 Views
- Accenture, I also Faced
- E-Mail Answers
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
What are the tuning techniques you applied during your last project
what is the hint? how to use it to reduce the query processing in program?
Explain the different lookup methods used in informatica?
How does a rank transform differ from aggregator transform functions max and min?
What is flashback table ? Advance thanks
What is the reusable transformation?
Target increases every day even though no new record was inserted
According to his methodology what all you need before you build a datawarehouse
What is the fact table?
What are the types of schemas we have in data warehouse and what are the difference between them?
What do you mean by channel change?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Tell me about Propagate functions in informatica
Difference between Target-based loading and constraint-based loading?
Clarify the utilization of aggregator cache record?
