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

what is confirmed fact?

2 18772

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 6440

in general which algorithms for used?

1 2106

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 6606

what is difference between mapping and mapplet ?

TCS,

2 18216

What is confirmed fact in dataware housing?

Hewitt, TCS,

3 7168

How to write duplicate records into a separate dataset using sort?

HSBC,

4 12919

Hot to suppress characters from a given string?

CTS,

4 10119

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

HCL, iGate,

2 6961

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

CTS, HCL, Infosys, TCS,

3 22939

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

Amdocs,

1 7716

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

Amdocs,

1 7577

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

Amdocs,

3 21484

What is the difference between SQl Loader and OCI in datastage?

CSC,

2 15035

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

CSC,

4 15923


Un-Answered Questions { Data Warehouse }

Write the unconnected lookup syntax and how to return more than one column.

1174


draw informatica architecture 8.6 ?

3949


What is the difference between business requirement document and use case document.

1086


Explain scd type 3 through mapping.

1076


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...................................

2334


Demonstrate experience in maintaining quality process standards?

2676


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2213


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

1144


What is a rollup component? Explain about it.

1246


EXL informatica Questions

1463


What r the names of the reports that you prepared?

1032


Are you involved in writing the inferential analysis plan? Tables specifications?

4019


What is dimensional table?

1168


can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306


how many reports have u created ? explain a few.

2162