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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Difference between output_index and output_indexes in reformat

 747

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

 510

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

 363

Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999

 457

Intern stastical programmer written test

 276

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

 340

Tell me about MD5 functions in informatica

 515

Tell me about Propagate functions in informatica

 518

How to update a particular record in target with out running whole workflow?

 1149

How you prepared reports for OLAP?

 1142

How you know when to use a static cache and dynamic cache in lookup transformation?

 1331

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

 1281

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

 1477

how to insert/update a csv file by comparing it with another csv file?

 1644

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

 490

Un-Answered Questions { Data Warehouse }

How to create diff. Types of templates?

554

What is called Cognos powerplay?

611

What are the different types of olap? Give an example?

551

What is the difference between router and filter?

637

Differentiate between sas functions and sas procedures.

635




To save time, can many reports be run at the same time?

585

What is powercenter on grid?

686

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1713

What is the difference between static cache and dynamic cache?

515

How can we create index after completion of load process?

590

What are the transformations that are not supported in mapplet?

591

What is the difference b/w macros and prompt?

584

Write the advantages of partitioning a session?

741

What is the flow of loading data into fact & dimensional tables?

587

Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

589

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