What is confirmed fact in dataware housing?
Answers were Sorted based on User's Feedback
Answer / ramesh
fact is a measure and methods of data is confirmed in
datawarehousing
| Is This Answer Correct ? | 1 Yes | 2 No |
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Differentiate between a repository server and a powerhouse?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
What is CHECK-IN CHECK-OUT. Please explane me?
checkout and checkin in informatica 8.6
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
how to load only the first and last record of a flat file into the target?
can you please explain me pre session and post session options?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
how can we check whether a particular cache is static or dynamic?
What are the measure objects?