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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

 516

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

 512

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

 549

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

 621

Difference between task flow and linear task flow

 585

Un-Answered Questions { Data Warehouse }

can be used COM component in Informatica ?

1613

What does P-value signify about the statistical data?

846

What is a bridge table ?

479

What task is 98% of the required work of a business analyst?

575

what is online view?

1514




What are the different components of powercenter?

578

what are several options for creating reports in web report studio? : Sas-bi

625

client know skid info?

1631

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1714

Explain what are the different types of join operations?

531

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

961

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1863

4 yrs etl devloper roles and responsibilities?any body give solutions

1567

What are the advantages of cognos?

566

what is the meaning of upgradation of Repository?

3293

For More Un-Answered { Data Warehouse } Questions Click Here