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
Answer Posted / shirishworld2000
Waiting for the response
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is Cognos script editor?
How to implement security measures using repository manager?
Why filter transformation is an active one?
How do you set a varible in incremental aggregation
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?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What you know about transaction control transformation?
How can we improve session performance in aggregator transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are data-driven sessions?
What are the limitations of joiner transformation?
State the differences between sql override and lookup override?
What is fact table? Explain the different kinds of facts.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.