ALLInterview.com :: Home Page
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
Categories >> Software >> Data Warehouse >> ETL
 


   

 

Question Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com
 Question Asked In Companies :: Accenture, CTS, Flextronics, HCL, Infosys, NexGen, Patni, Wipro, College School Exams Tests, SO,     < I also faced this Question! >
 Question Submitted By :: guest
  Answer Posted By  
 
Answer
Please post it to abh_vish@yahoo.com too.
Thanks a lot

Is This Answer Correct ?    4 Yes 4 No


 
  abhay
 
View All Answers
 
 
Please Help Members By Posting Answers For Below Questions
 
 Question Views   Select
 
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype) 1132
flat filevalidation in informatica 674
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase? 772
how do u handle performance issues in Informatica . where can u monitor the performance ? 2953
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1. 621
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why? 473
what is dynamic insert? 560
list and discuss two approaches for updation of target table in Informatica and how they are different. 779
what are the concerns of OLTP and DSS systems? 521
what is the use of structures?how many nodes can u create in a structure? 717
what is data modeling? 923
what is session partitioning? 560
what is the difference between cubes and package in cognos 2294
architural difference between 7.1 workflow monitor and 8.1 workflow monitor. 920
Identifying the bottlenecks in various components of Informatica and resolving them. 1017
E-Mail New Answers        Answer Selected Questions