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

 741

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)

 506

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

 359

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

 448

Intern stastical programmer written test

 270

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

 335

Tell me about MD5 functions in informatica

 510

Tell me about Propagate functions in informatica

 512

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

 1147

How you prepared reports for OLAP?

 1138

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

 1323

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

 1273

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

 1464

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

 1637

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.

 309

Un-Answered Questions { Data Warehouse }

Name the various types of filters?

554

What is the difference between orabulk and bcp stages?

562

What all the types of jobs you developed?

656

Slowly changing dimensions, types and where will you use them

1258

what other sas products have you used and consider yourself proficient in using? : Sas programming

669




What are the limitations of joiner transformation?

641

Enlist the advantages of informatica.

614

What are the key configuration files in obiee?

551

What is decode in informatica?

640

Differentiate between joiner and lookup transformation?

599

Explain the key challenges that you face while performing etl testing.

559

What are ETL Tools?

653

Tell e how how dealt with..

1754

How to update source definition?

619

what is pmrep command?

10791

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