How can i explain my project architecture in interview..? in
Igate asked me tell me your project flow from source to
target..?
Answer / manojdubba
Project architecture is like
1. Source Systems: Like Mainframe,Oracle,People soft,DB2.
2. Landing tables: These are tables act like source. Used
for easy to access, for backup purpose, as reusable for
other mappings.
3. Staging tables: From landing tables we extract the data
into staging tables after all validations done on the data.
4. Dimension/Facts: These are the tables those are used for
analysis and make decisions by analyzing the data.
5. Aggregation tables: These tables have summarized data
useful for managers who wants to view monthly wise sales,
year wise sales etc.
6. Reporting layer: 4 and 5 phases are useful for reporting
developers to generate reports. I hope this answer helps you.
Is This Answer Correct ? | 55 Yes | 2 No |
What does command task mean?
Explain pushdown optimization $pushdownconfig parameter - informatica
what is junk dimension
Why filter transformation is an active one?
what is SDLC way of code development?
What is source qualifier transformation in informatica?
Can we create out put ports in source qualifier t/r?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
how will you remove the duplicate records from flat file without using sorter?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
what is shared Cache. when we will use shared Cache?