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 |
Explain pushdown optimization and types in informatica
What is a predefined event?
what is distinct
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the tasks that source qualifier performs?
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
what is constraint based loading
Write the different tools in the workflow manager?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How Union Transformation is an Active Trans?
what is the difference between static and dynamic