in u flatfile some of fact records are missed then u load
the diminision records are not if u load diminsion records
what about fact table records
No Answer is Posted For this Question
Be the First to Post Answer
what are the real time problems generally come up while doing or running mapping or any transformation?
what are the limitation of sorter transformation?
WHAT IS FACT TABLES?
How the Informatica Server reads perameter file?
what is hash table in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the tuning techniques you applied during your last project
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
What are the reusable transforamtions?
How to load duplicate records in to a target table which has a primary key?
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me