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

How Union Transformation is an Active Trans?

6 Answers  


following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,


Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,


What is staging area?

11 Answers  


how to create user defined function (udf) in informatica

0 Answers   Informatica,


write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,


Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,


How you count the number of records available at your source?

3 Answers   Zensar,


Difference between Target-based loading and constraint-based loading?

0 Answers  


can we create index and drop index in exsisting table while using infomatica

4 Answers  


can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,


What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  


Categories