Explain the etl program with few examples.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,


what is data driven in informatica

5 Answers   IBM,


What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,


What is update override?

1 Answers   Accenture,


What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


Mapplets can you use an active transformation in a mapplet,

1 Answers  


If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,


how to duplicates from expression transformation without using sorter before that

1 Answers  


i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,


In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,


Categories