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 |
Why union transformation is an active transformation?
disable caching in a lookup transformation?
What is a configuration management?
What is the command used to run a batch?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
What is meant by a domain?
What is a data modeling?