How can yoU create or import flat file definition in to the
warehouse designer?
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 is confirmed fact in dataware housing?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the advantage of persistent cache? When it should be used.
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
What is olap (on-line analytical processing?
What are the new features of informatica 9.x in developer level?
Explain one complecated mapping?
Can you use one mapping to populate two tables in different schemas
How can you recover the session in sequential batches?