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
- 9390 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / abhinav
I am not sure if the solution I am going to post will
actually work but it is worth a shot:
1. Don't define a delimiter so that the records are read
as '100,200,A B,300' and '200,400,X,Y,299' and so on i.e.
as a single record. This is to ensure that all the records
pass the source-qualifier.
2. Now you have all the records including the faulty one in
SQ. Next, you put an expression where you use REPLACECHAR
to remove all the commas from all the records. Now ALL your
records will of the same length.
3. Next you can use SUBSTR to read the first 3 numbers to
get the first column, next 3 to get the second column and
so on and so forth to get proper data in proper columns.
My explanation might not be clear but I have a hunch that
this might work.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Is it possible to use a client with different version than that of its Informatica server?
Explain the tuning lookup transformation - informatica
How to load data in informatica ?
What is an aggregator transformation?
Tell me about MD5 functions in informatica
What is option by which we can run all the sessions in a batch simultaneously?
What is meant by LDAP users?
How to generate sequence numbers using expression transformation?
Explain the difference between mapping parameter and mapping variable?
What is a pre-defined event and user-defined event?
What are the settings that you use to configure the joiner transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the limitations of joiner transformation?
How to use procedural logic inside infromatica?
How do you convert single row from source into three rows into target?
