Interested to Buy Any Domain ? << Click Here >> for more details...
How to load a relational source into file taget?
- 2 Answers
- 6923 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 |
Please let me know how to make encryption and decryption with example?
What is option by which we can run all the sessions in a batch simultaneously?
what is Partitioning ? where we can use Partition?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
What is a sequence generator transformation?
How to convert flat file into xml file? How to tune joiner?
What is mapplet in informatica?
Different types of Power center errors?
Why is sorter an active transformation?
Does Facttable Normalized or Denormalized?
Which kind of index is preferred in DWH?
Teradata 
