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

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,


Differentiate between a database and data warehouse?

0 Answers  


without using rank transformation how can we rank items by using some other transformations

2 Answers  


what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  


What happens when a session fails and you click on recover?

0 Answers  


if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,


How will you convert rows into columns or columns into rows

1 Answers  


Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers   TCS,


how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  


what is confirmed fact?

2 Answers  


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,


What is the fact table?

0 Answers  


Categories