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
- 9399 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / naveen
By using replace char function we can write this
Suppose
length(replacechr(c3,'1234567890abcdefghtijklmnopqrstuvwzyz',null))
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we override a native sql query within informatica?
Explain dynamic target flat file name generation in informatica
What is the format of informatica objects in a repository?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is a snowflake schema?
Define Pmrep command?
What you know about transaction control transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What does command task mean?
what is Active lock explain
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a surrogate key?
what is unit testing?tell me proceedure
What are the modules in Power Center
