How to load relational source into file target?
Answers were Sorted based on User's Feedback
Answer / rkumar.etl
use mapping designer create source db file as well as tgt
flat file with required column information .
While creating session provide the tgt file directory to get
the information.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / jang
It should be a direct 1-1 mapping, source having relational
table and Target a Flat file
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kammari.krishnaiah
load the data form source system to target in two ways.
one is directly storing another one is mapping (etl)in
infirmatia
| Is This Answer Correct ? | 0 Yes | 2 No |
What are the different components of powercenter?
How to generate a single mapping for both the historical and incremental load.
COM components can be used in Informatica
How are indexes created after completing the load process?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
draw informatica architecture 8.6 ?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
How to improve the performance of a session using sorter transformation?
what are the different types of transformation available in informatica and what are the mostly used ?
what is shared Cache. when we will use shared Cache?
How do you convert single row from source into three rows into target?
What are the connected or unconnected transforamations?