Interested to Buy Any Domain ? << Click Here >> for more details...
In mapping f.f as one src and f.f as trg,f.f as src and
oracle as trg which is fast? mean which is complete first
process
- 2 Answers
- 7327 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ramesh
flatfiles is fast then oracle,because in flat files there
is no constraints.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is rank transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How identifying bottlenecks in various components of informatica and resolving them?
What does refresh system mean, and what are its distinctive choice?
What is meant by query override?
Difference between Target-based loading and constraint-based loading?
Explain scd type 3 through mapping.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to convert multiple rows to single row (multiple columns) in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
tell me the rules and responsblites in our project(my project is development)
Why is sorter an active transformation?
How to create a non-reusable instance of reusable transformations?
