Where should yoU place the flat file to import the flat file
defintion to the designer?
Answers were Sorted based on User's Feedback
Answer / sri ram
If Informatica server and client are in one machine, then
we can place it in local folder.other wise,
But I strongly, recommend that better place the files to be
imported to the designer in
<directory>:/informatica/...../Src /<.csv file>
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sunil
Flat File Should Be there in Client Machine with sample
data to import the flat file definition along with correct
datatypes.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / abhinav
You can place the flat file on your local system.
Go to Source Analyser > Click on the Source > Import from
File and then browse to the file that you want to use as a
source.
Is This Answer Correct ? | 0 Yes | 2 No |
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the use of source qualifier?
What are the active and passive transforamtions?
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 to partition the Session?
case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
what is index?how it can work in informatica
What are mapplets? How is it different from a Reusable Transformation?
Can you start a session inside a batch individually?
which one is better performance wise joiner or look up
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
In operator is used in which transformation in informatica 8.6.0