What are the types of data warehouses?


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

Post New Answer

More Informatica Interview Questions

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,


How do you load only null records into target? Explain through mapping flow.

0 Answers  


How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  


In update strategy target table or flat file which gives more performance ? why?

7 Answers  


write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,






What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  


Can you generate sequence numbers without using the sequence generator transformation?

0 Answers  


what is the difference between lookupoveride and joiner?

3 Answers  


Explain the use of aggregator cache file?

0 Answers  


hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,


What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,


wat are deployement groups in informatica, how it will be used for developers

0 Answers  


Categories