Interested to Buy Any Domain ? << Click Here >> for more details...
surrogate keys usage in Oracle and Informatica?
- 5 Answers
- 15584 Views
- ITC Infotech, Oracle, I also Faced
- E-Mail Answers
Answer Posted / ranjan
surrogate key is one type of key which is used to maintain
history .
it is used in slowly changing dimension (scd)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
how to load rows into fact table in data warehouse
How to create the source and target database connections in server manager?
What is the way to execute pl/sql script using informatica mapping?
How do you load only null records into target?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
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 the difference is between a database, a data warehouse and a data mart?
How can you generate reports in informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Describe the impact of several join conditions and join order in a joiner transformation?
Differentiate between source qualifier and filter transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the restrictions of union transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
