Hi, I am new to Informatica, What is a flat file and how to
use flat file in infomratica please help me.
Answer Posted / rabikant thakur
Please ignore my first ans. i miss to write "not"
Here is currect ans:
Flat file like Notepad,MS-Word Flat file does not maintain
the referential integrity and property like RDBMS and
seprated with some delimeter like
comma and tab
| Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
What are the different clients of powercenter?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Can we change Dynamic to Static or Persistent cache? If so what happens?
tell me the rules and responsblites in our project(my project is development)
What are the types of caches in lookup?
How to open an older version of an object in the workspace?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the need for an etl tool?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
how tokens will generate?
What are the performance considerations when working with aggregator transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Clarify the utilization of aggregator cache record?