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 |
What is a connected transformation?
I have 1200 records how can u send it in aggregator with good performance issues?
What happens when a session fails and you click on recover?
What is transformation?
Explain the use of aggregator cache file?
What is partioning?how many types of partinings are there
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
what is the flat file partition and where have to specify it
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
can any one explain me about junk dimension
How to Migrate the UNIX SCRIPTS from SIT TO PROD?