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 |
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
How many types of sessions are there in informatica.please explain them?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
what type of transformation is not supported by mapplets?
what is diffrence b/w joner and union transfermation
What is the exact difference b/w IN and EXIST in Oracle..?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
Which gives the more performance when compare to fixed width and delimited file ? and why?
if i am having 10 records in source, i want 20 records in target...how will you do it
What are the different threads in DTM process?
How to eliminate duplicate records in informatica mapping? Explain with an example....
what is diff b/t sorter t/r and agg have the option sorter property...