Data Warehouse Interview Questions
Questions Answers Views Company eMail

How to generate sequence numbers using expression transformation?

Informatica,

633

What is Index Caches size?

Informatica,

612

What is Session and Batches?

Informatica,

658

Explian the connected and unconnected lookup transformation

Informatica,

1 869

What is the Rank index port in Rank transformation?

Informatica,

666

What are mapplets? How is it different from a Reusable Transformation?

Informatica,

619

I have a flat file, want to reverse the contents of the flat file

Informatica,

684

which one is better performance wise joiner or look up

Informatica,

618

write a query to retrieve the latest records from the table sorted by version(scd)

Informatica,

627

How many types of sessions are there in informatica.please explain them?

Informatica,

670

Which transformation is needed while using the Cobol sources as source definitions?

Informatica,

721

What is an unconnected transformation?

Informatica,

659

What is the status code in stored procedure transformation?

Informatica,

683

Explain dynamic target flat file name generation in informatica

Informatica,

642

update strategy transformation in informatica

Informatica,

635


Un-Answered Questions { Data Warehouse }

What is the opening step in basic teradata query script?

591


What is the importance of having monitor service in cognos?

575


What is tracing level? How many types of transformations supported by sorted input?

539


What are “business rules” in ab initio business rules environment (bre)?

1414


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

627






I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2374


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

1620


what are the uses of fact table and dimension table in banking project?

4093


What is the use of stop statement?

634


Which transformation should we use to normalise the COBOL and relational sources?

736


What tools would you use for that?

560


Does microstrategy web support clustering via cisco local router or any other third-party clustering software?

546


Where the cache files stored?

542


How to configure mapping in informatica?

672


While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

517