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 |
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How can we update a record in the target table without using update strategy?
why u go for dimensions ?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
what is the gap analysis?
What are the phases in SDLC?
What is mapplet and a reusable transformation?
What is meant by lookup transformation?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
how can we perform incremental aggregation?explain with example?
WAT IS TEXT LOAD?