Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Data Warehouse Interview Questions
Questions Answers Views Company eMail

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

Bank Of America,

4 8954

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2249

what is the difference between copy object import objects using repositery manager which one is best

TCS,

1 4145

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

TCS,

2263

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

Patni,

3 7440

in realtime which situations u can use unconnected lookup transformation

Patni,

2 8301

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

Patni,

3 9927

i have source in oracle 10g,oracle 8i how will u take the data from two sources

TCS,

2 5053

why we are using surogate key in real time give me explanation

TCS,

2 7122

How informatica process data means how informatica works?

TCS,

2 13175

Can we run session without using workflows?

TCS,

5 22329

how many modules are there in telecome domain?how to explain the architecture?

2029

Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.

HSBC,

6 18612

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

HCL, HP,

2 7842

what is the location of parameter file in informatica?

TCS,

1 8478


Un-Answered Questions { Data Warehouse }

Your account is locked and your administrator has forgotten the password. What would you do?

1045


What is a bridge table ?

897


Explain what are data marts?

1132


explain one complex mapping with logic? sales project?

6691


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8233


can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2269


What are the steps to build the datawarehouse?

1049


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1514


How the Bursting happens in same report and how to Print the bursting Report?

1872


Explain batch?

998


Can anyone explain me a scenario from banking and finance...more precisely a mapping

2511


what do u do when DB time takes more?in sap bi

2214


What are the data marts?

988


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1028


What is partitioning? What are the types of partitioning?

1179