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 |
Enlist few areas or real-time situations where informatica is required.
Explain joiner transformation in informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
Have you worked with/created Parameter file
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
Why you use repository connectivity?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
how can u approach u r client
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
How can u stop a batch?
What is a surrogate key?
Can any one explain or sujjest some sites for scd mappings.Thank you