From where you extract the data, how you did it into
informatica? explain....
Answer Posted / davankumar
Its imp ??? every company should ask these ???.If source is
relation tables source data is relational (ie means oracle
9i/10g)
But source is flat that can in unix server(client can give
path details ).in informatica we have to create the
sturuture of table and give that path address in the
session property tab.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is a filter transformation and why it is an active one?
How many ways are there to create ports?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain the etl program with few examples.
Different sorts of metadata that stores in the storage facility?
how tokens will generate?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is status code in informatica?
How are the sources and targets definitions imported in informatica designer?
How to load last n records of file into target table - informatica
What is a sequence generator transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are Dimensional table?