can anyone explain me about sales project in informatica?
Answer Posted / rajesh
im explained earliarly as follows,
im working under insurence domain project, usually i
extract the data from defferent sources like flat files,
oracle, db2.
first we load the extracted data into intermidiate staging
area, where we are having 150 tables, and again we extract
data from intermediate staging area and we load into an
other staging area where we are having event and value base
tables
we transfom the data into staging according to the business
requirement , to transform the data i used trasformations
like expression, lookup,update strategy,joiner wtc
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Differentiate between source qualifier and filter transformation?
What is the fact table?
explain abt ur project architecture?
What are the guidelines to be followed while using union transformation?
What is the use of an aggregator cache file?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Is it possible to define a single node as a Gateway node as well as worker node?
How does a sorter cache works?
How can informatica be used for an organization?
How to load the data from people soft hrm to people soft erm using informatica?
How to elaborate powercenter integration service?
What is incremental aggregation?
How union transformation is used?
Differences between version 7.x and 8.x.
permutations of mapplet