Hi 2 every one. i dont have real time experience, and please
suggest me for following questions.
a) we get the source data from what type of source systems?
b) In banking domain project what are the FACT & DIMENTION
tables please list out them?
c) please write some colomn names in a table?
Please reply for aboue questions?..... Thanks in advance.
Answer / kishor baindoor
a) source can be Flat files , Cobol Files , Oracle table etc
b) Fact table will be having main data where as dimention
ttable describes attributes of fact table. primary keys for
ddimentional table will foreign key of fact table. go
through dimentional modelling.
| Is This Answer Correct ? | 11 Yes | 0 No |
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
write a query to get maximum salary from the employers table without duplicates....kindly help me
What are the options in the target session of update strategy transsformatioin?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
What is the meaning of up gradation of repository?
how can we run workflow with pmcmd?
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
What is the difference between router and filter?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???