Interested to Buy Any Domain ? << Click Here >> for more details...
Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse
- 5 Answers
- 25332 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / abhishek
ranjan is right its all depend on that how many years old
data u are going to keep in your warehouse
first dimension will load and then on base of dimension we
load fact table
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
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?
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 we can use union transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Separate from an archive server and a powerhouse?
Explain the different lookup methods used in informatica?
What is the format of informatica objects in a repository?
4 yrs etl devloper roles and responsibilities?any body give solutions
Differentiate between source qualifier and filter transformation?
what are the deliverables?in your project?
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 .
Is it possible to create multiple domains on a single Informatica server?
Describe an informatica powercenter?
What are the measure objects?
What is intricate mapping?
