Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose we have a csv file with contents as below which is
used has a source file.
C1,C2,C3,C4
100,200,A B,300
200,400,X,Y,299 ---> it should be 4 values but by mistake
300,600,C D,566 with a comma in between X & Y,its 5.
My target takes only 4 columns, How to take care of the 2
record as above without rejecting it and loading in the target.
Hope u guys have understood my scenerio
- 4 Answers
- 9163 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shirishworld2000
Waiting for the response
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Global and Local shortcuts. Advantages.
What is the difference between Active and Passive transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
explain abt ur project architecture?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
lookup transformation with screenshots
What is the way to execute pl/sql script using informatica mapping?
Explain the use of aggregator cache file?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How we can create indexes after completing the loan process?
What is the difference between stop and abort in informatica
What is a grid in Informatica?
Slowly changing dimensions, types and where will you use them
Different sorts of metadata that stores in the storage facility?
