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

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,

4732

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 7207

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

4 23330

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

Virtusa,

5 15944

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 12963

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

2225

How can we load single row of data into teradata database. please give me the process.

3 10026

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

Cap Gemini,

7 16649

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

Polaris,

3 7390

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

L&T,

7 13859

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

2 5378

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

1 5287

What is the language used in Ab Initio ?

4 15674

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 12392

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 17078


Un-Answered Questions { Data Warehouse }

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2013


What are the steps to create a repository in ab initio?

1260


Explain differences between star and snowflake schemas?

1163


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2370


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2191


When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

1159


Explain what is the advantages data mining over traditional approaches?

1030


What are the functions used for character handling?

1262


How to call shell scripts from informatica?

1001


Can any one explain about core dimension, balanced dimension, and dirty dimension?

1057


Which command is used to save logs in the external file?

1105


What are the data types present in bo? What happens if we implement view in the designer and report?

1032


Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1692


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

4392


Is Redshift similar to RDS ?

5