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
- 9048 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / naveen
By using replace char function we can write this
Suppose
length(replacechr(c3,'1234567890abcdefghtijklmnopqrstuvwzyz',null))
| Is This Answer Correct ? | 0 Yes | 1 No |
how can run the wf through pmcmd commend? write script?
how can i invoke pmcmd in command line prompt
How to prepared lld.can any one tell me detailed explanetion.
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
complex mapping ur project u r invlve can u explain and give real time example give me ?
Where is metadata stored?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
How You Pull the records on daily basis into your ETL Server.
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
what is the difference between lookupoveride and joiner?
Which is the t/r that builts only single cache memory?
Teradata 
