Interested to Buy Any Domain ? << Click Here >> for more details...
How can i explain my project architecture in interview..? in
Igate asked me tell me your project flow from source to
target..?
- 1 Answers
- 21971 Views
- Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro, I also Faced
- E-Mail Answers
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 |
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
What are the types of maping wizards that r to be provided in Informatica?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
what is the difference between onsite & client site?
How can we update a record in the target table without using update strategy?
how we do performence tuning in informatica
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
Design time, run time. If you don't create parameter what will happen
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is mapping parameter?
What did you do in source pre load stored procedure
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
Teradata 
