tell me some dimension tables names in banking domain
informatica project(dont tell like depends on project, tell
me names of dimension and fact table names in your project)?
Answers were Sorted based on User's Feedback
Answer / im
Fact Tables:
1)Bank
2) Advanced
Dimension Tables:
1)Customer
2)Account
3)Transation Dirty Dimension
4)Time
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / lokesh
Table which contains account number,customer numbers.........
| Is This Answer Correct ? | 9 Yes | 12 No |
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
To import the flat file definition into the designer where should the flat file be placed?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a taget load order?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
What is a mapplet/worklet in informatica?
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 .
What does cheating measurement mean?
one source to target loading insert new rows and update existing rows?