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
- 9233 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 are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Why union transformation is an active transformation?
how tokens will generate?
What does command task mean?
lookup transformation with screenshots
what is informatica metadata?
How to generate sequence numbers using expression transformation?
Mention a few design and development best practices for informatica?
What are the prerequisite tasks to achieve the session partition?
How are indexes created after completing the load process?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is a snowflake schema?
What are ETL Tools?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How to do unit testing in informatica? How to load data in informatica ?
