Answer Posted / subbu
by using the date coll in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the surrogate key?
Explain the different kinds of facts.
What are the new features of informatica 9.x in developer level?
What are mapplets?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the different clients of powercenter?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the sql query overwrite in source qualifier in informatica
Please let me know how to make encryption and decryption with example?
State the limitations where we cannot use joiner in the mapping pipeline?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the function of look up transformation?
Is it possible to use a client with different version than that of its Informatica server?
How union transformation is used?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.