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

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 9357

source file is having 5 records while moving into target it want to be 10 records

IBM,

4 11467

where exactly determinants are used in cognos framework manager?

Satyam,

4 26916

how will compare two mappings in two different repository?

Real Time, TCS,

2 32156

without using emailtask how will send a mail from informatica?

3 10060

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

IBM, TCS,

5 9138

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

TCS,

5 8704

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

2111

Which Teradata concept allows more than one model generation?

TCS,

1 10880

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 7830

what is meant by report busting

TCS,

2 6894

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 4096

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

IBM,

2 5699

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

Cognizant, IBM,

1975

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

IBM,

1 3101


Un-Answered Questions { Data Warehouse }

Differentiate primary key and partition key?

997


Explain what are the measure objects?

1006


what is the primary data source for the wrs? : Sas-bi

1254


Which are the different editions of informatica powercenter that are available?

1041


What r the names of the reports that you prepared?

990


What is SAS informats?

1115


Which transformation we use to convert 'NA' to 'Not Available'

1282


What is the need for an etl tool?

1081


How to join three sources using joiner?

1129


What is cfapplication tag?

976


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1888


What is the dense rank?

1242


What is the extension of file to save template?

1017


What the difference between “look-up” file and “look is up” in abinitio?

1372


What is the difference between microstrategy and cognos reporting tool?

1002