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
Answers were Sorted based on User's Feedback
Answer / sai krishna karri
ff as source and ff as target, this will be the faster
process. Because writing to the flatfile is faster than
writing it into a database.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ramesh
flatfiles is fast then oracle,because in flat files there
is no constraints.
| Is This Answer Correct ? | 3 Yes | 0 No |
how to convert the .doc docs into .txt format using informatica
Can anyone tell me the new features in Informatica 9 Version?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
which quality process u can approach in ur project
Enlist few areas or real-time situations where informatica is required.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is an expression transformation in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Name 4 output files that informatica server creates during session running?