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
- 7830 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
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain how many types of dimensions are available in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain the aggregator transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the prerequisite tasks to achieve the session partition?
What is a rank transform?
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.
How can repository reports be accessed without sql or other transformations?
What are the different ways to implement parallel processing in informatica?
What are the differences between oltp and olap?
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 are data-driven sessions?
