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
How can you validate all mappings in the repository simultaneously?
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)
without dynamic lookup how to insert new rows and update existing rows?
How can repository reports be accessed without sql or other transformations?
How to generate sequence numbers using expression transformation?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
Describe an informatica powercenter?
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
I have 1200 records how can u send it in aggregator with good performance issues?
What is the difference between writing a joiner query in ANSI style and THETA style?
Why is sorter an active transformation?
How to improve the performance of Aggregate transformation?