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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

HSBC,

7 20171

we r using aggregator with out using groupby?

HSBC, Principal Finance,

7 20045

how to we create datamart?

HSBC,

2 7012

wht is cdc?how to use it in creation of mappings?

HSBC,

6 20648

wht target override?wht advantages it has compare to target update?

Polaris,

2 12864

can anybody tell me about issues faced while creating reports

Accenture, Tech Mahindra,

1 2106

Can anybody tell me about issues faced while creating universe. thanks in advance

Accenture,

1 11463

can anybody tell me about issues faced while creating reports

Accenture,

3 8073

can anybody tell me about complicated object you have created

 2761

how many user were there

 1 3838

what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

Patni,

3 15475

how many reports have u created ? explain a few.

InfoStep, Ness Technologies, TCS,

1 4456

can anybody tell me how many classes where there and objects in each class

 3 5036

how many reports have u created ? explain a few.

Bank Of America, TCS,

1669

Name statements that function at both compile and execution time.

L&T,

3 7897

Un-Answered Questions { Data Warehouse }

Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

653

What do you mean by fastexport in teradata?

567

How do you load only null records into target? Explain through mapping flow.

1511

explain in detail about type 3?

635

in u r data u having duplicates how to fetch the latest data in our report?

4627




permutations of mapplet

2048

Explain clustering algorithm?

1858

What is star schema and snowflake schema?

534

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

7833

How to go to the older version for a mapping?

613

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3331

What are components of report studio?

540

What data formats does Redshift Spectrum support?

5

how to create cubes in transformer ?

624

How co>operating system integrates with legacy codes?

621

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