Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

CTS,

1 1737

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

CTS,

1 1762

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

CTS,

1 1700

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

CTS,

1 2488

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

Alpharithm Technologies,

1 1582

How to load specific no.of records using bteq, or fastload,or multiload

Infosys,

1 1830

What is the difference between a utility and api in a RUN SQL component

Accenture,

1 8465

What is use Array size in datastage

1 1846

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

1 3946

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

Alpharithm Technologies,

1 3720

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1 1751

If the job aborted in a sequencer, how can we start that from the previews successful job.

SLK Software,

1 3530

What is the size of database for you project?

Accenture,

1 1655

we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?

Accenture,

2 3053

New coloums are added in database, then how you know in report level

Accenture,

1 1660

Un-Answered Questions { Data Warehouse }

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..

2767

How to create the source and target database connections in server manager?

1144

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

Write the unconnected lookup syntax?

1148

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1997

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2546

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

what are the dimensions that you have in your current project?list them?

2093

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660

Explain about a time when you discovered a more efficient way to do a work task?

1222

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

What sort of existing documents should business analysts refer to when starting on a new project?

1078

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

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