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)

 513

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

 459

Intern stastical programmer written test

 279

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

 341

Tell me about MD5 functions in informatica

 517

Tell me about Propagate functions in informatica

 520

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

 1149

How you prepared reports for OLAP?

 1145

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

 1282

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.

 510

Un-Answered Questions { Data Warehouse }

what is proc Index? and what is proc document?

1985

suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?

537

How to join three sources using joiner? Explain though mapping flow.

688

how do u identify the changed records in operational data?

2131

What is difference between informatica power mart and power center?

558




How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

630

What is a Query Subject?

655

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

1642

describe about metadata object? : Sas-di

617

How to read an input file in sas?

646

what is null hypothesis? why do you consider that?

2409

Tell us about the architecture of abinitio.

644

What do you mean by a transaction file and how it is different from that of a sort file?

623

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

576

In general, how do you optimze any sql in teradata?

541

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