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 9097

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

1 2300

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

TCS,

1 4233

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,

1 2310

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 7545

in realtime which situations u can use unconnected lookup transformation

Patni,

2 8404

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

Patni,

3 10052

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

TCS,

2 5168

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

TCS,

2 7228

How informatica process data means how informatica works?

TCS,

2 13310

Can we run session without using workflows?

TCS,

5 22547

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

1 2072

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 18806

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 7938

what is the location of parameter file in informatica?

TCS,

1 8557


Un-Answered Questions { Data Warehouse }

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

838


Write the unconnected lookup syntax?

1139


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2161


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2163


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202


How to create the source and target database connections in server manager?

1139


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2305


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2081


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2415


What is a rollup component? Explain about it.

1232


What is rollup component?

1324


how to generate the test data in sas without input data? : Sas-administrator

1194


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2099