Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shyam
Dimension table contains the textual information to analyse
the business. It contains more number of column as compare
the less no. of rows.
There are the four types of dimention table in the
Datawarehousing.
1. Confirmed Dimension
2. Shared Dimension
3. Degenerated Dimension
4. Jun Dimension.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to do unit testing in informatica? How to load data in informatica ?
Explain scd type 3 through mapping.
What is the difference between Active and Passive transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
How can we remove the duplicates from flat file source?
What is data caches/ index caches?
Which is the t/r that builts only single cache memory?
Explain direct and indirect flat file loading (source file type) - informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is a connected transformation?
How can informatica be used for an organization?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How can you increase the performance in joiner transformation?
What is sq transformation?
