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 |
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the target load order?
How can we improve session performance in aggregator transformation?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
How to Create a folder using pmrep command?
What is the sequence generator transformation in informatica?
how can u load the data in time dimension?
How can we eliminate duplicate rows from flatfile,explain?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.