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
- 9225 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
How to generate or load values in to the target table based on a column value using informatica etl tool.
what is SDLC way of code development?
can we override a native sql query within informatica? Where do we do it? How do we do it?
how we can load rejected record's at run time?(not through bad files)
What are the differences between oltp and olap?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Can anyone tell me the new features in Informatica 9 Version?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Is it possible to use a client with different version than that of its Informatica server?
What's the layout of parameter file (what does a parameter file contain?)?
generate date / time dimension in informatica
What is an active transformation?
What is meant by pre and post session shell command?
What is dimensional table?
