Explain the etl program with few examples.
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
what is data driven in informatica
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
What is update override?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
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?
Mapplets can you use an active transformation in a mapplet,
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.
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.
how to duplicates from expression transformation without using sorter before that
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
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