What is confirmed dimension with scenario
Answer / rajeshkumar
A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts. Date is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can yoU use the maping parameters or variables created in one maping into another maping?
What is the need of etl tools?
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
What are the informatica performance improvement tips
How do you manage the Parameter files while migrating your data from one environment to another environment?
what happens when a batch fails?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
What is the maplet?
how to load duplicate row in a target