Interested to Buy Any Domain ? << Click Here >> for more details...
How to read data from flat file source if the data is in paragraph format?
- 2 Answers
- 4917 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sajid
In order to read data from flat file, your must have to be in readable format first. Informatica cannot read/understand the flat file which contains the unstructured data.
By using UNIX shell script or third party tool you will have to bring your data in readable format. When I say in readable format means you will have to use some delimiter in flat file to separate the one column value to another column.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
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
Explain transaction control transformation in informatica
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is a router transformation?
Enlist the advantages of informatica.
What is intricate mapping?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is meant by a domain?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
server hot-ws270 is connect to Repository B. What does it mean?
design of staging area?
Can informatica load heterogeneous targets from heterogeneous sources?
How can you differentiate between powercenter and power map?
my source is junk data how will u remove that junk data by using unix please any one replay me
