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

 757

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)

 530

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

 378

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

 463

Intern stastical programmer written test

 288

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

 356

Tell me about MD5 functions in informatica

 528

Tell me about Propagate functions in informatica

 526

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

 1161

How you prepared reports for OLAP?

 1155

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

 1343

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

 1311

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

 1485

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

 1670

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.

 899

Un-Answered Questions { Data Warehouse }

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4078

What is primary and backup node?

702

What are universe requirements?

541

How to get sql from obiee for reports?

536

Differentiate between a repository server and a powerhouse?

581




What are the steps to create a data model?

602

What is a filter transformation?

573

What is meant by Reportstudio shortcut?

1729

Explian the Process of deployment groups in informatica

659

describe about physical data integration? : Sas-di

561

Can we create a Integration service without a Repository service and vice versa?

729

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

1671

How is character variable converted into numeric variable and vice versa?

600

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

1919

Can u generate reports in Informatica?

658

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