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



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..

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

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..

Answer / 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

More Informatica Interview Questions

what is the location of parameter file in informatica?

1 Answers   TCS,


What is the difference b/w natural key and surrogate key

1 Answers  


whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,


What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  


what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,


How do you implement unconn. Stored proc. In a mapping?

1 Answers  


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 ??

3 Answers   IBM,


What are multi-group transformations?

0 Answers   Informatica,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,


What are the advantages of informatica?

0 Answers  


What is A cache?

2 Answers  


Categories