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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1691


What are data-driven sessions?

706


how to load rows into fact table in data warehouse

629


How to use pmcmd utility command?

572


How do you load unique records into one target table and duplicate records into a different target table?

694






In development project what is the process to follow for an etl developer from day1

1268


How to elaborate powercenter integration service?

639


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

776


What is rank transformation?

564


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

620


scenario where i can use only concurrent execution of workflow.

2528


How to create the source and target database connections in server manager?

614


What are the steps involved in the migration from older version to newer version of Informatica Server?

1572


Explain sessions?

594


Explian the Process of deployment groups in informatica

646