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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.

IBM,

1 2782

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

iGate,

4 6522

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

Wipro,

2 5759

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

DELL,

5 9225

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

TCS,

5 6288

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

Mind Tree,

1 6860

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

Infinite Computer Solutions,

1 12085

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

IBM,

3 6021

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

CTS,

1599

tell me 5 session failure in real time how can you solve that in your project?

CSC,

1627

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

CGI,

2 5547

explain about unit testing? in real time?

L&T,

1653

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

Polaris,

1 5473

wf dont have integration severances how you can run?

TCS,

1539

how can run the wf through pmcmd commend? write script?

Cap Gemini,

2 7554

Un-Answered Questions { Data Warehouse }

In development project what is the process to follow for an etl developer from day1

1276

Can anyone give me an example of realtime start script in the graph?

667

update strategy transformation in informatica

636

Which version configuration tool used in ur project?

2762

Can you define slice?

621




What is the process of killing a job in datastage?

585

Whats there in global repository

1262

10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?

1996

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

1679

Which transformation should we use to normalise the COBOL and relational sources?

738

for whom is sas data integration studio designed? : Sas-di

554

What is a bridge table ?

479

What is a method to debug and test your SAS program?

713

What does Amp contain and what are all the operations that it performs?

585

If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?

607

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