What are the main features of Oracle 8i with context to datawarehouse?


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

Post New Answer

More Informatica Interview Questions

How can you validate all mappings in the repository simultaneously?

0 Answers  


if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,


without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,


How can repository reports be accessed without sql or other transformations?

0 Answers  


How to generate sequence numbers using expression transformation?

0 Answers   Informatica,






How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,


Describe an informatica powercenter?

0 Answers  


we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,


I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  


What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,


Why is sorter an active transformation?

0 Answers  


How to improve the performance of Aggregate transformation?

3 Answers   Dmss,


Categories