Advertise your Business Here      Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new    Refer this Site               Login  |  Sign Up                       Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories  >>  Software  >>  Data Warehouse  >>  ETL        Suggest New Category      Question  Asked @ Answers Views     select   when should one create lookup transformation ?  1  110 what is the difference between date cache and lindex cache?  0  36 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.  0  39 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?  0  38 Two default user groups created in the repository are____and_____.  0  148 Two different admin users created for repository are________and_________.  0  36 when will use SQL override in a lookup transformation?  0  51 what is the advantage of persistent cache? when it should be used?  0  46 can be used COM component in Informatica ?  0  88 can cubes contain measures ?  0  33 dimension object created in oracle can be imported in designer?how?  0  35 what are business components in Informatica?  0  42 how do u implement configuration management in Informatica?  0  100 what is the difference between shortcut of an object and copy of an object? compare them?  0  40 How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?  0  57 E-Mail New Answers        Answer Selected Questions     Prev    1   2   3   4   5   6   7    [8]   9   10    Next         Teradata Interview Questions     Business Objects Interview Questions     Cognos Interview Questions     Informatica Interview Questions     Crystal Enterprise Suite Interview Questions     Actuate Interview Questions     Ab Initio Interview Questions     Data Stage Interview Questions     SAS Interview Questions     Micro Strategy Interview Questions     ETL Interview Questions     Data Warehouse General Interview Questions       Un-Answered Questions    Question Views Asked at   Select   list and discuss two approaches for updation of target table in Informatica and how they are different. 35   how would u estimate the size of Lookup transform data and index cache? 34   what are the parts of Informatica server ? 53 GE what is an ETL or ETT? And what are the different types? 34   what are Lookup caches options? Including persistent caches. 34   Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping. 29   can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine. 36   what is pmrep command? 32   Can u access a repository created in previous version of Informatica? 125   how does the server recongnise the source and target databases.Elaborate on this 41 Accenture Identifying the bottlenecks in various components of Informatica and resolving them. 47   how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration? 31   what happens if the info.server doesn't find the session parameter in the parameter file? 77   what is the difference between cardinality and Nullability? 32   what is Forward,Reverse and Re_engineering? 26   how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa. 27   Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance 68   what are the data modeling tools you have used?(polaris) 39   what is the difference between cardinality and Nullability? 39   what is the meant by Normalization and de-normalization? 36   E-Mail New Answers        Answer Selected Questions

Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |            Copyright © 2007  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com