|
Related Questions |
View Answer |
|
How can you delete duplicate rows with out using Dynamic Lookup? Tell me any other ways using lookup delete the duplicate rows?
|
View Answer
|
|
In realtime which one is better star schema or snowflake star schema
the surrogate will be linked to which columns in the dimension table.
|
View Answer
|
|
What is the mapping for unit testing in Informatica, are there any other testings in Informatica, and how we will do them as a etl developer. how do the testing people will do testing are there any specific tools for testing
|
View Answer
|
|
How do u check the source for the latest records that are to be loaded into the target. i.e i have loaded some records yesterday, today again the file has been populated with some more records today, so how do i find the records populated today.
|
View Answer
|
|
While running multiple session in parallel which loads data in the same table, throughput of each session becomes very less and almost same for each session. How can we improve the performance (throughput) in such cases?
|
View Answer
|
|
Can Informatica load heterogeneous targets from heterogeneous sources?
|
View Answer
|
|
How do you load the time dimension.
|
View Answer
|
|
What are the properties should be notified when we connect the flat file source definition to relational database target definition?
|
View Answer
|
|
What is hash table informatica?
|
View Answer
|
|
What is meant by EDW?
|
View Answer
|
|
How to load the data from people soft hrm to people soft erm using informatica?
|
View Answer
|
|
What are the measure objects
|
View Answer
|
|
How can we join the tables if the tables have no primary and forien key relation and no matchig port to join?
|
View Answer
|
|
If the workflow has 5 session and running sequentially and 3rd session hasbeen failed how can we run again from only 3rd to 5th session?
|
View Answer
|
|
What is the diff b/w STOP & ABORT in INFORMATICA sess level ?
|
View Answer
|
|
What is the diff b/w Stored Proc (DB level) & Stored proc trans (INFORMATICA level) ? again why should we use SP trans ?
|
View Answer
|
|
What is surrogatekey ? In ur project in which situation u has used ? explain with example ?
|
View Answer
|
|
In my source table 1000 rec's r there.I want to load 501 rec to 1000 rec into my Target table ? how can u do this ?
|
View Answer
|
|
What is Partitioning ? where we can use Partition? wht is advantages?Is it nessisary?
|
View Answer
|
|
How can we eliminate duplicate rows from flat file?
|
View Answer
|