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
How does a rank transform differ from aggregator transform functions max and min?
Write the program through which the records can be updated?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is dimensional table? Explain the different dimensions.
Differentiate between joiner and lookup transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is Data Caches size?
How to create a non-reusable instance of reusable transformations?
COM components can be used in Informatica
How many ways are there to do 'remove duplicate records in informatica'?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Can we get 1st record through Informatica(without sequence number).
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the types of presistent cache in look up tr.
How to do the error handling of if ur source is flatfiles?