Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

wht is full process of Information source to target

just like stg to productuon and development

Question Posted / jai


wht is full process of Information source to target just like stg to productuon and development..

Answer / krishna

Initially data comes from OLTP systems, of a company, which
get loaded into a database or flatfiles with the help of
legacy systems or any pre defined methods. from here data
is transferred to the staging database applying business
logic with the help of informatica or other ETL tools. at
times stage to target is also loaded using informatica
mappings. these are transferred to another QA(quality
analysis database) in XML files. from there deployment is
done onto the production environment.

Is This Answer Correct ?    6 Yes 3 No

Post New Answer

More Informatica Interview Questions

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

Can we run session without using workflows?

5 Answers   TCS,

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

why we are using surogate key in real time give me explanation

2 Answers   TCS,

what is the location of parameter file in informatica?

1 Answers   TCS,

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

tell me the push down optimization

2 Answers   Wipro,

How can we handle two sessions in informatica?

0 Answers  

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

For more Informatica Interview Questions Click Here
Categories