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

Post New Answer

More Informatica Interview Questions

what is confirmed dimension?

6 Answers  


1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,


How an expression transformation differs from aggregator transformation?

0 Answers  


Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  


Enlist the tasks for which source qualifier transformation is used.

0 Answers  






hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,


What is the Difference between sorter and aggregator?

2 Answers  


Define mapping and session?

0 Answers   Informatica,


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?

0 Answers  


What is pmcmd command?

0 Answers  


Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,


Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  


Categories