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
- 9039 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
Briefly describe lookup transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
can you please explain me pre session and post session options?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the format of informatica objects in a repository?
How to create Target definition for flat files?
What does cheating measurement mean?
What is transformation?
define galaxy repository in informatica
What is sq transformation?
How many dimensions are there in informatica?
What is difference between a gateway node and worker node?
What is the benefit of partitioning a session?
