can anyone explain me about sales project in informatica?
Answer Posted / kumar
Hi Mr.Manthiramoorthy , thanks for valuable information.
Could you plz tell generally how many dimensions and fact table are there in sales DWH and how frequently we load them(daily or weekly or ....).
You can also mail to 'myetlblog@gmail.com ' . Cheers...
Thank you.
Regards,
Kuamr.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are the differences between oltp and olap?
Can you generate sequence numbers without using the sequence generator transformation?
What is mapplet in informatica?
Explain incremental aggregation in informatica
Different sorts of metadata that stores in the storage facility?
Define pmcmd command?
Write the different tools in the workflow manager?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the limitations of joiner transformation?
What is joiner change?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are different types of transformations available in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain about Informatica server process that how it works relates to mapping variables?