Interested to Buy Any Domain ? << Click Here >> for more details...
How can yoU create or import flat file definition in to the
warehouse designer?
- 2 Answers
- 8688 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
yoU can not create or import flat file defintion in to
warehouse designer directly. Instead U must analyze the file
in source analyzer,then drag it into the warehouse designer.
When U drag the flat file source defintion into warehouse
desginer workspace, the warehouse designer creates a
relational target defintion not a file defintion. If u want
to load to a file, configure the session to write to a flat
file. When the informatica server runs the session, it
creates and loads the flatfile.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / gayatri
u can create or import ff into target defination designer
too select target designer-> create-> geve ff name and
select database type select flat file option can create this
way.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different types of Type2 dimension maping?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are some examples of informatica etl programs?
How can you access the remote source into your session?
As union transformation gives UNION ALL output, how you will get the UNION output?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
What is aggregate awareness?
Enlist the advantages of informatica.
How to join three sources using joiner? Explain though mapping flow.
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
Teradata 
