How can yoU create or import flat file definition in to the
warehouse designer?
- 2 Answers
- 7584 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 |
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
Why update strategy and union transformations are active? Explain with examples.
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
What are the mapping paramaters and mapping variables?
What is hash partition?
If informatica has its scheduler why using third party scheduler?
what is inline view?
without update strategy how to insert &update?
How to do Integration testing in Informatica?
how to design mapping half of source table records into one target and remaining half into another target
How Union Transformation is an Active Trans?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
Teradata 
