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 Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a node in Informatica?

619


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1836


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1620


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1403


Separate from an archive server and a powerhouse?

491






What is informatica? Why do we need it?

636


What are the different types of transformation available in informatica.

634


Can u generate reports in Informatica?

651


Explain dynamic target flat file name generation in informatica

645


How to start a workflow using pmcmd command?

710


What is the difference between Active and Passive transformation?

631


Enlist the differences between database and data warehouse.

545


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

596


What is the meaning of decode in informatica?

644


How do we call shell scripts from informatica?

593