What is the grain level in DWH? If i have year to day. what
is the grain level of DWH from year to day.
Answer / raj
At What Level the data stored in the data ware house.
day in lowest level grain in the data ware house
| Is This Answer Correct ? | 5 Yes | 1 No |
why sequence generator should not directly connected to joiner transformation ?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
what is a time dimension? give an example?
how can we run workflow with pmcmd?
How to get EVEN & ODD numbers separately?
Can we insert ,update ,delete in target tables with one update strategy tran.?
what is the difference between Informatica7.1 & informatica 8.1
why we use datawarehouse
how to run 2 workflows sequentially. plz respond what is the process?
What are ETL Tools?
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
Which kind of index is preferred in DWH?