Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / krishna
a dimension table contains the master data pertaining to a
subject area. this table is referenced by the fact table
when it is loaded.
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
Why filter transformation is an active one?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is primary and backup node?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is a repository manager?
What is a repository? And how to add it in an informatica client?
How to create Target definition for flat files?
What is a joiner transformation and why it is an active one?
Differentiate between reusable transformation and mapplet.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the new features of informatica 9.x in developer level?
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 .
Enlist the various types of transformations.
How big was your fact table
What is the different lookup cache(s)?
