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
- 9165 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / dj
ou can do this by executing a pre session unix command. Replace consecutive delimiters with some Junk value and later in informatica mapping replace it with null.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is mean by complex business rule ?
Can we create two repositories on same database instance in oracle?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is option by which we can run all the sessions in a batch simultaneously?
What's the layout of parameter file (what does a parameter file contain?)?
Explain sessions?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the use of source qualifier?
How to go to the older version for a mapping?
Differentiate between Load Manager and DTM?
Where is metadata stored?
What is rank transformation?
How to generate sequence numbers using expression transformation?
What is rank transformation in informatica
What is an aggregator transformation?
