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 / 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 View All Answers
What are the types of caches in lookup?
what are the Methods For Creating Reusable Transformations?
How to convert multiple rows to single row (multiple columns) in informatica
What is the need of etl tools?
What is the session task and command task?
What the difference is between a database, a data warehouse and a data mart?
Different qualification between a related rotate toward the sky and isolates look upward?
Define enterprise data warehousing?
What is the use of target designer?
how to load dimension table and fact table. plz tell me the steps.
What do you mean by worklet?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is difference between a gateway node and worker node?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .