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
- 7831 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 the surrogate key?
How do you load only null records into target? Explain through mapping flow.
Mention a few design and development best practices for informatica?
How would you copy the content of one repository to another repository?
generate date / time dimension in informatica
Explain Dataware house architecture .how data flow from intial to end?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is the difference between Active and Passive transformation?
differences between service based and product based?
What is workflow manager?
What is the use of source qualifier?
Explain constraint based loading in informatica
What is meant by LDAP users?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Make a note of the quantity vaults made in informatica?
