Sign Up Login


  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

 985

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)

 700

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

 585

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

 1 1176

Intern stastical programmer written test

 480

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

 536

Tell me about MD5 functions in informatica

 680

Tell me about Propagate functions in informatica

 693

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

 1338

How you prepared reports for OLAP?

 1338

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

 1538

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

 1704

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

 1730

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

 2058

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.

 1969

Un-Answered Questions { Data Warehouse }

What are initial page components of Cognos connection?

790

what are factless facts? And in which scenario will you use such kinds of fact tables.

1509

How do you take back up of repository?

898

What are the advantages of informatica?

744

What are some prerequisites for datastage?

816

Explain about Informatica server process that how it works relates to mapping variables?

812

Explain ibm infosphere information server and highlight its main features?

827

Can you define cognos powerplay?

828

what are the names of the reports that you prepared?

784

Have you have ever worked in unix environment and why it is useful in datastage?

893

what the mean of version error in crystal?

2027

What is meant by a Channel Driver?

830

Explain which are the olap tools available that are supported by oracle?

728

Can more than 1 metric be applied on an analytic in business objects?

1833

In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

740

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