how we load the data from source to staging area
Answer Posted / cm
use sql loader
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the different versions of informatica?
How to load a Dimension ? and how to load a fact table?
According to his methodology what all you need before you build a datawarehouse
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the mapping parameters and mapping variables?
Which transformation is needed while using the Cobol sources as source definitions?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain the difference between a data warehouse and a data mart?
scenario where i can use only concurrent execution of workflow.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How do you remove duplicate records in informatica? And how many ways are there to do it?
In warehouses how many schemas are there?
What is a connected transformation?
Define sessions in informatica etl?
What are the differences between oltp and olap?