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
- 9038 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shirishworld2000
Waiting for the response
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a standalone command task?
How can we use mapping variables in informatica?
Explain constraint based loading in informatica
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Define pmcmd command?
How to update or delete the rows in a target, which do not have key fields?
What is expression transformation?
What is joiner transformation?
Why is sorter an active transformation?
What is meant by lookup transformation?
What is informatica metadata and where is it stored?
What are the popular informatica products?
What is the scenario which compels informatica server to reject files?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
