Differentiate between a database and data warehouse?


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

Post New Answer

More Informatica Interview Questions

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,


What is sq transformation?

0 Answers  


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  


when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,


how to load rows into fact table in data warehouse

0 Answers   Informatica,






wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,


every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,


How to load last 10 records of flat file in to the target?

5 Answers   iNautix,


we have to use order by,where,having we to implement sql query

1 Answers   Satyam,


error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  


Parameter and variable differences

0 Answers  


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  


Categories