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 |
how to load dimension table and fact table. plz tell me the steps.
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
How to generate the HTML output using Informatica.
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
in what type of scenario bulk loading and normal loading we use?
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
what is the dashbords?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
How to eliminate 1st and last rows from the source and load the inbetween rows.
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE