How can we create index after completion of load process?
No Answer is Posted For this Question
Be the First to Post Answer
Why update strategy and union transformations are active?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
Slowly changing dimensions, types and where will you use them
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
where to store informatica rejected data?
Can we use parameters of parameter file in presession command
What is the procedure to load the fact table.Give in detail?
connected and unconnected lookups?
What is a predefined event?
How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?
How to recover sessions in concurrent batches?
Is there any way to read the ms excel datas directly into informatica?