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
- 9394 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 substr in informatica?
How many numbers of sessions can one group in batches?
What are the components of the workflow manager?
Explain the difference between a data warehouse and a data mart?
What can we do to improve the performance of informatica aggregator transformation?
How identifying bottlenecks in various components of informatica and resolving them?
Difference between Target-based loading and constraint-based loading?
What is a difference between complete, stop and abort?
What is repository manager?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How would you join a node to the already existing domain?
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain pushdown optimization and types in informatica
What are batches?
what is $$$$?
