What is dimensional table? Explain the different dimensions.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,


how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,


Reusable transformation and shortcut differences

0 Answers  


HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,


differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,






we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,


how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,


3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,


what is surrogate id ?

3 Answers   IBM,


what is incremental aggregation ,with example?

2 Answers  


If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  


What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,


Categories