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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

IBM,

4 11564

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

Emphasis,

3 6808

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

Emphasis,

2 5348

what is curr val use for in sequence generator?

Emphasis,

2 6368

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

Emphasis,

1 4013

what is the necessity to use update strategy?(except for updates)

Emphasis,

2 5143

What is the method of seperating unique and duplicate records in session level?

Emphasis, JBL, Wipro,

2 9171

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

Accenture,

6 9872

what is the difference between a data item and a query item?

Bodhtree, HP,

2 14027

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

 6 7962

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

IBM,

1796

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

IBM,

5 9936

HOW TO PUBLISH A REPORT IN BO?

Polaris,

1 6477

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

TCS,

1 4954

How do you find what type of trap is there by seeing the report?

TCS,

4 5972

Un-Answered Questions { Data Warehouse }

Explain the pipeline partition with real time example?

644

How would you configure wh authentication? Explain.

521

COM components can be used in Informatica

1864

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

565

What is local and formal parameter?

760




how to test reports in cognos?

580

What do the SAS log messages "numeric values have been converted to character" mean?

876

Can we Save (save as) WEBI Doc as DESKI?

7051

What is etl process? How many steps etl contains?

586

How to limit decimal places for the variable using proc means?

587

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3124

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1395

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1028

What is a difference between complete, stop and abort?

630

Does Amazon redshift based on concept cluster?

5

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