How many cubes create from a single model?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??
HOW DO YOU CONNECT TO REMOTE SERVER ?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
wht is cdc?how to use it in creation of mappings?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
How to load a relational source into file taget?
What is a difference between complete, stop and abort?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
any body can say about all versions of informatica ?how many versions ?
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
What is a snowflake schema?