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 are the informatica performance improvement tips
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
In ur current projectu have done any performance tuning of mappings?
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 using aggregator & router? how
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
What is the need of building a data warehouse?
Describe an informatica powercenter?
when will we go for unconnected lookup transformation in Informatica?
What are the different components of powercenter?
What's the layout of parameter file (what does a parameter file contain?)?
Explain sessions and how many types of sessions are there?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z