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 |
Define mapping and session?
What is source qualifier transformation in informatica?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
Differentiate between mapping parameter and mapping variable?
Why is sorter an active transformation?
Write the program through which the records can be updated?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
in a table it has 200 rows the query is select 150 from tablename.whats the output
what is the diff b/w target load plan and cbl?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists