design of staging area?
No Answer is Posted For this Question
Be the First to Post Answer
What is the fact table?
in performance wise union is past,union all is past
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
How to load query faster,so that It will take less time to load?
how can u approach u r client
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
Reusable transformation and shortcut differences
where does the default group roew in a router is stored what is the default size of memory in router
Explain load alternative records / rows into multiple targets - informatica
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
how to design mapping half of source table records into one target and remaining half into another target