Interested to Buy Any Domain ? << Click Here >> for more details...
How can yoU create or import flat file definition in to the
warehouse designer?
- 2 Answers
- 8594 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 |
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
What is meta data and system catalog?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
Can we create multiple integration service on single repository?
Different circumstance which drives informatica server to expel records?
What is informatica worklet?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
Teradata 
