Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between flat files and relational sources?
- 2 Answers
- 6089 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasanna
if ur sources are flat files then you cannot give any SQ
override queries.
to join 2 flatfile sources you need to have a joiner
transformation.
If ur target is a flat file, the loading process is very
fast as its a bulk load where there will be no constraints
( no checks)
You can have number and char data types... but for dates,
you need to convert explicitly
many more diff are there...
You can use indirect method and use many flatfiles of same
structure and load to a target using one session and
workflow tasks.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is tracing level? How many types of transformations supported by sorted input?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Define Dynamic push down optmization?
Explain what is etl process? How many steps etl contains explain with example?
tell me few points when u become TL
flat filevalidation in informatica
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
What do you understand by active and passive transformations?
What is the difference between round-robin partitioning and hash partitioning?
What is fact? What are the types of facts?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What is a mapping, session, worklet, workflow, mapplet?
how does the server recongnise the source and target databases.Elaborate on this
explain the methodology of Data Warehousing?(Polaries)
how do u set partition points in the mapping?
