there is a comma separated flat file as source and there is
a column in that one field is having space like "rama
krishna" like that what happens when this is used as source
Answers were Sorted based on User's Feedback
Answer / srinivas
i have tested when we use coma seperated file it should
take only rama krishna as single column
Is This Answer Correct ? | 23 Yes | 0 No |
Answer / kishore
Hi,
I think ...it will take separate column when comma(,) occurs
only..... "rama krishna: as single column only....
Is This Answer Correct ? | 11 Yes | 1 No |
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
8.what is mapplet ?give example?
What are the advantages of informatica?
How can repository reports be accessed without sql or other transformations?
I want load the data into target with out 1st and last record.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
How do you recover rows from a failed session
what is the location of parameter file in informatica?
What are the different types of Type2 dimension maping?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.