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 |
Using Connected or unconnected lookup for performance wise which one is preferable?.
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
What are the Differences between connected and unconnected lookup?
How to elaborate powercenter integration service?
What is target load order?
How do you change a non-reusable transformation to reusable transformation?
how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?
I have source like this 1:2;3. so i want to load the target as 123
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
Enlist the advantages of informatica.
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
What is batch and describe about types of batches?