Answer Posted / nikhil tiwari
check this site for SCD-2 step by step implementation:
http://deepinopensource.blogspot.in/2013/03/scd-2-implementations-in-informatica.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
Did u used latest transformations of 8.6.0? for what?
What is parallel processing in informatica?
What does refresh system mean, and what are its distinctive choice?
can u give example for factless fact table
Explain how to import oracle sequence into informatica?
What are the types of caches in lookup? Explain them.
What is meant by lookup transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Enlist few areas or real-time situations where informatica is required.
differences between service based and product based?
Explain in detail about scd type 1 through mapping.
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 main features of Oracle 8i with context to datawarehouse?
How do you convert single row from source into three rows into target?