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 Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
How to delete first 3 rows & last 3 rows in target table in informatica
in what type of scenario bulk loading and normal loading we use?
Two Default User groups created in the repository are ____ and ______
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
Why do we need informatica?
Explain sessions?
how to work with mapplet designer in informatica?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?