Data Warehouse Interview Questions
Questions Answers Views Company eMail

What is shift table? have you ever created shift that?

Accenture, Clinical Research, Quintiles,

2 26522

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

CTS,

6 7276

can i call router is a passive transformation

2 4962

what is the difference between filter and router transmissions

2 5482

how can i provide security to my reports in report studio?

TCS,

3 6015

what is work of PUSH DOWN option

Wipro,

2 6234

who to split dimentions into sub dimention

Wipro,

3 6378

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 3730

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

Wipro,

10 13623

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 8368

It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

1934

what is reprompt?

TCS,

3 17852

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

CTS, IBM,

3 20882

what is DSS?

3 5118

hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...

2 3499


Un-Answered Questions { Data Warehouse }

What are the different types of repositories created using informatica?

653


How is MLOAD Teradata Server restarted after execution?

646


What is a node in teradata? Explain

599


Explain what are the steps to do to use alerts in bo?

611


what is proc Index? and what is proc document?

1992






what is the difference between list and crosstab?

5


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1640


What is dimensional table? Explain the different dimensions.

653


How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

528


List out some of the primary characteristics of teradata.

551


How to compare two dmls in abinitio

1184


What is the difference between STOP and ABORT options in Workflow Monitor?

691


What interface is used to connect to windows based applications?

580


What are the functionalities of link collector?

623


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2252