From where you extract the data, how you did it into
informatica? explain....
Answer / 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 |
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
replace multiple spaces with single space.
how to design mapping half of source table records into one target and remaining half into another target
Explain the pipeline partition with real time example?
What do you understand by term role-playing dimension?
What is the difference between Power Centre and Power Mart?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
What are the advantages of using informatica as an etl tool over teradata?
What are the connected or unconnected transforamations?
In session log thier should not be a single error how will u do
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?