Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / deepu
The good advantage of using Informatica it enables to work
with both relational and non-relations source and targets.
So , now to load a data from relation to flatfile follow
the steps:
1,Extract the Sourec table (i.e orcale, teradata any
reational)
2, create a target table (FlatFile) let it be fixed with r
delimiter as per the data in the source table then creat
the columns and make the point that the datatype must match
to that of the datatype in the source table .
3, Built a mapping considering the needed
transformations .
4, configure the source and target in the workflow manager .
5 . and execute the job....
check out properlly the properties setting at workflow
manager .
Thanks & Regards
Deepu
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What does “tail –f” command do and what is its use as an Informatica admin.
Differentiate between router and filter transformation?
How many number of sessions can one group in batches?
Global and Local shortcuts. Advantages.
What will be the approach?
server hot-ws270 is connect to Repository B. What does it mean?
What is InformaticaPowerCenter?
How identifying bottlenecks in various components of informatica and resolving them?
What is the need of etl tools?
Enlist the differences between database and data warehouse.
How can we improve session performance in aggregator transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is the difference between source qualifier transformations source filter to filter transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to do unit testing in informatica?
