Informatica

Get new comments by email
You can cancel email alerts at anytime.
Comments (4)

sama in Bradley, Illinois

70 months ago

I am loading data from flat file to table,where I am seeing a special char as box in a column,so how can I skip that when reading from line.
it seems as seperate line above that char that is why I am getting a special char as box.

Please let me know

- Was this comment helpful? Yes / No Reply - Report abuse

Mahesh in Neshanic Station, New Jersey

70 months ago

I am also facing the same problem right now in informatica.

Reading a flat file with special characters like box while loading the data to a target database.

please let me if any of you have read the file with a special character box

- Was this comment helpful? Yes / No Reply - Report abuse

Mahesh in Neshanic Station, New Jersey

70 months ago

I was told to use COALEASE function ( it exists in oracle )
but not in informatica.

thanks/mahesh

- Was this comment helpful? Yes (2) / No (1) Reply - Report abuse

nagesh_connect in Bombay, India

68 months ago

You can use 'coalesce' function in sql over write

- Was this comment helpful? Yes (1) / No (2) Reply - Report abuse

» Sign in or create an account to comment on this topic.