Interested to Buy Any Domain ? << Click Here >> for more details...
How to load a relational source into file taget?
- 2 Answers
- 6845 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nagaraju bhatraju
Target Types are File, Relational and ERP. Latest Answer :
PowerCenter can load data into the following targets:
Relational. Oracle, Sybase, Sybase IQ, Informix, IBM DB2,
Microsoft SQL Server, and Teradata. File. Fixed and
delimited flat file and XML. Application. You can purchase
additional PowerCenter Connect ...
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain how many types of dimensions are available in informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
how to create a sample mapping for dynamic lookup transformation
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
What is CDC? How to implement CDC?
How would you join a node to the already existing domain?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
can u give example for factless fact table
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
what is informatica metadata?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
Teradata 
