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 |
what is the location of parameter file in informatica?
What is the difference b/w natural key and surrogate key
whats the logic to load the lower level of granularity of data to fact table.
What is the difference between sequential batch and concurrent batch and which is recommended and why?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
How do you implement unconn. Stored proc. In a mapping?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
What are multi-group transformations?
Diff b/w ShortCut and reusabel Object ?
How you load distinct records into one target and duplicate records into another target?
What are the advantages of informatica?
What is A cache?