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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

IBM,

4319

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

IBM,

2 6153

what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-

4 21930

what is the best stage in datastage parller jobs to use full out join and why

Virtusa,

5 14102

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

Virtusa,

3 11732

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

 1755

How can we load single row of data into teradata database. please give me the process.

 3 8803

without dynamic lookup transformation how to insert new rows and update existing rows?

Cap Gemini,

7 14350

one source to target loading insert new rows and update existing rows?

Polaris,

3 6057

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

L&T,

7 11739

Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?

 2 4465

Please some body send me Ab Initio material in my mail ... sitakanta2009@gmail.com Thanks in Advance!!!

 1 4500

What is the language used in Ab Initio ?

4 13533

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

L&T,

5 10529

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

BirlaSoft, Genpact, L&T, Syntel,

9 14579

Un-Answered Questions { Data Warehouse }

What is the commit type if you have a transaction control transformation in the mapping?

656

hi friends pls forward impropmtu interview question

1691

Explain the special input delimiters used in sas programming.

589

How you will check the version of teradata?

592

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1322




What is static and local variable?

565

what is SAS OPTIMIZATION?

1819

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

641

Global and Local shortcuts. Advantages.

1472

Explain the difference between a data warehouse and a data mart?

600

Difference between cold fusion 5 and cold fusion mx 6?

589

Difference between flat files and relational sources?

1737

In informatics server which files are created during the session rums?

639

What is the difference between dependent data warehouse and independent data warehouse?

607

explain about balanced dimension,

569

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