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,

4317

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 6152

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

4 21917

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

Virtusa,

5 14099

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 11729

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 8799

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

Cap Gemini,

7 14344

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

Polaris,

3 6054

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

L&T,

7 11732

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

 2 4462

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

 1 4496

What is the language used in Ab Initio ?

4 13524

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 10521

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 14565

Un-Answered Questions { Data Warehouse }

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

556

Differentiate between sessions and batches?

576

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6389

Explain what are the tasks that loadmanger process will do?

483

in general which algorithms for used?

1559




What are the possible data marts in retail sales?

539

how to implement scd2 in datastage 7.5 with lookup stage

5135

How to RD using transformer?

868

How do you convert single row from source into three rows into target?

607

What does cheating measurement mean?

600

What are the special input delimiters used in SAS?

656

Which is the t/r that builts only single cache memory?

714

How do you promote a non-reusable transformation to reusable transformation?

663

list out all the transformations which use cache?

691

What are the benefits of using AWS Redshift?

5

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