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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

how to return multiple columes through through un-connect lookup?

DELL,

1 5948

explain one complex mapping with logic? sales project?

Accenture, JPMorgan Chase,

6131

Performance tuning in UNIX for informatica mappings?

CGI, CTC,

2126

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

 1 2244

How to do the error handling of if ur source is flatfiles?

 1493

In ur current projectu have done any performance tuning of mappings?

 1 3941

In which scenario did you used pushdown optimization?

 1 2531

In which scenario did u used Mapping variable?

Cognizant,

1 1897

In Which scenario did u used Incremental loading?

 2 5228

Did u used latest transformations of 8.6.0? for what?

 1467

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

 1 6931

what is semi-additive fact?where did u used?

 2 4421

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 3207

In dimension and fact table? which one holds big data?

2 5550

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

ACS,

3 6571

Un-Answered Questions { Data Warehouse }

What are symget and symput? : sas-macro

713

What are all the problems you faced while validating tables and reports?

2994

what is Forward,Reverse and Re_engineering?

1762

To which project that prefix will set is to private project or public project or both?how and where to set?

1388

How do you load unique records into one target table and duplicate records into a different target table?

693




What are the types of security?

532

what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

608

explain the methodology of Data Warehousing?(Polaries)

1790

Explain how are the dimension tables designed?

551

What are the advantages and disadvantages of reporting directly against the database?

533

How you can differentiate between connected lookup and unconnected lookup?

600

Explain what is data step?

717

How do you design a report which has multiple child datastream (horizontal seq)

2125

What does cheating measurement mean?

588

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2393

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