Can we change Dynamic to Static or Persistent cache? If so
what happens?
No Answer is Posted For this Question
Be the First to Post Answer
How do you promote a non-reusable transformation to reusable transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the restrictions of union transformation?
What is Performance tuning in Informatica?
what is metadata?
What is the difference between router and filter?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is union transformation?
how did u understand business requirement?
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?