Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.
Answer Posted / abhiram
"FLAT FILE IS A FILE HAVING DATA IN DIFFERENT FORMAT"
(OR)
"THE FILE WHICH CONTAINS PARTICULAR STRUCTURE"
TO EXTRACT FLATFILE JUST CLICK.
SOURCE ANALYZER-IMPORT FLAT FILE(i.e.,WE CAN EXTRACT
THE FAT FILE WHICH IS LOCATED IN LOCAL SOURCE DATABASE).
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How can you differentiate between powercenter and power map?
how we can load rejected record's at run time?(not through bad files)
What is informatica worklet?
Mention some types of transformation?
What are the advantages of informatica?
Reusable transformation and shortcut differences
what is Active lock explain
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain the types of lookup transformation?
How to create the source and target database connections in server manager?
What is rank index in rank transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are roles and groups and benefits of using them?
What is fact table? Explain the different kinds of facts.