How to load a relational source into file taget?
- 2 Answers
- 7098 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 |
What are the reusable transforamtions?
If u r using dynamic cache lookup port will be thier in thet which option u will select
Implementation methodology
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
How can we update a record in the target table without using update strategy?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
How do you convert single row from source into three rows into target?
What are the different tools in workflow manager?
without update strategy how to insert &update?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
After we make a folder shared can it be reversed?Why?
Teradata 
