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


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,

1173

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,

1238

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,

1190

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 1559

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,

1074

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

Infosys,

1307

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

Accenture,

1 6786

What is use Array size in datastage

 1292

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

 3309

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 2572

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?

 1224

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

SLK Software,

1 2648

What is the size of database for you project?

Accenture,

1097

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 1911

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

Accenture,

1140

Un-Answered Questions { Data Warehouse }

Slowly changing dimensions, types and where will you use them

1258

What is conduct>it?

621

How to a create header dynamically in a crosstab report in cognos 8.1?

1979

Mention what is PROC in SAS?

587

What is report template in b.o?

567




Explain the data types present in bo and what happens if we implement view in the designer and report?

548

how can you get the errors in job? when loops are araised we get error?

1641

Briefly state different between data ware house & data mart?

545

How is the teradata different from oracle?

611

What is job control?

616

How to generate iqd file from framework manager?

511

In Teradata, how do we Generate Sequence?

592

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

507

Nls stands for what in datastage?

716

What are the different methods ot loading a dimension table? A fact table etc?

568

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