GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 111 of 312    Print  
what is the complex mapping? how we can build?

  
Total Answers and Comments: 2 Last Update: May 09, 2007     Asked by: rma 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 29, 2006 14:36:26   #1  
Usha        

RE: what is the complex mapping? how we can build?
In real time as per business logic we need to build the mapping using number of transformations, for example if you are trying to pass millions of rows with number of transformations and writing sql overwrite etc.. I mean to say lot of manipulations depending on business logic.  I hope this helps.,
 
Is this answer useful? Yes | No
May 09, 2007 09:42:28   #2  
SRIRAM N        

RE: what is the complex mapping? how we can build?
Complex mappings means not a map with more than 100 transformations used in.
Even 5 transformations used mapping also called complex enough.
It depends on business logic. If the requirement has too much business restrictions and constraints used to implement with informatica then it is complex.
Another thing, if the map looks complex to you, and it may not be complex to others.

If any one asked in interview like, means the complexity that you were faced while developing mapping thats it. It may not be complex to the interviewer.

For any further queries write to me: sriram_kumar @ oneindia . in

 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions we design 4 dimension mappings to load data into 4 dimensions ...

In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?
Read Answers (9) | Asked by : reddy

1) what is the difference between power center and power mart?2) diff b/w versions of Informatica 5, 6 an d7?3) what is ODS?4) how to give mapping & session parameter in file?
Read Answers (4) | Asked by : pratyusha

What is the main difference between mapping and mapplet designer in etl informatica and what transformations are used in the both?

I am asked to create a detailed metadata about ,transformations used in perticular fact table mapping.How do i understand and create write up on what has happened to each port during each tranformations?By right click on port in target definition and choosing backward path , I could get complete path fot that port.Pls. adviseThanks,
Read Answers (1) | Asked by : Adi
Tags : Metadata

Can anyone tell me , How to understand the use of transformations in informatica mapping for particular target port?
Read Answers (8) | Asked by : Adi

In Source 1 to 100 numbers? How can we load the even number in One target and odd number in another target?explain the mapping?How can we draw and wich transformations we r using?and explain logic?
Read Answers (5) | Asked by : Reddy

Latest Answer : Hi,Export your mapping to XML file and then Import it to Client machine .  I am assuming here the client and your system as same version and environment for Informatica.-Sphurti. ...
Read Answers (1) | Asked by : uday

I want to send the excle sheet as a souce to another excel sheet as target.so i created a mapping with souce excel sheet to target sexcel sheet correctly. but i'm faling to enter the correct connection string in establishing relatonal connections for type ODBC .My ODBC data source is XL(Microsoft Excel Driver(*.xls)). tell me what is the connection string for ODBC (Like oracle is the conn string for Oracle services)
Read Answers (1) | Asked by : sasha

When i try to connect to the repository server i am getting this message can someone help me..Starting Repository [infa_rep](6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit.(6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending.(6016|1292) Informatica Repository Agent starting up.(6016|1292) Security
Read Answers (4) | Asked by : Raju007


 Sponsored Links

 
Related Articles

EDI Mapping and Translation

EDI Mapping and Translation Mapping is a movement of information basically of putting the format of one data document onto another For instance it takes the format of an otherwise incompatible data format and makes it into an EDI compatible data document or conversely takes an EDI document and makes
 

What is Data Mapping

Data mapping is a very important aspect in data integration. In fact, it is the first step in the many complex tasks associated with data integration which include data transformation or data mediation between a data source and its destination; identification of relationships in data which is vital
 

How To Build Customer Loyalty With CRM

How To Build Customer Loyalty With CRM In order for a CRM system to become successful a company must make it an integral part of their philosophy and corporate strategy As I have stated in previous articles it is not simply enough to view CRM as simply being another technological solution It is a pa
 

How Leaders Can Build A Strong Team

How Leaders Can Build A Strong Team To be a great leader you will want to build a powerful team It doesn t matter how successful you are or plan to be To succeed you must know how to assemble the best people This is important whether you are a coach general or corporate executive mosgoogle The team
 

How To Build On The Five Paragraph Essay

How To Build On The Five Paragraph Essay If you are in high school you should be familiar with what is called the five paragraph essay The basic pattern will be composed of five things and these things are the introduction three body paragraphs and the conclusion or summary mosgoogle While the fiv
 

.NET Complex Data Binding

In this tutorial you will learn about Complex Data Binding Binding to a ComboBox or ListBox Binding to a DataGrid mosgoogle Complex Data Binding Complex data binding is the ability of a control to bind to more than one data element typically more than one record in a database or to more than one of
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape