can anyone explain me about sales project in informatica?
- 8 Answers
- 42635 Views
- MBT, Satyam, I also Faced
- E-Mail Answers
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
How many types of sessions are there in informatica.please explain them?
How can informatica be used for an organization?
Differences between connected and unconnected lookup?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How can we use mapping variables in informatica?
What is the Rank index port in Rank transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is informatica powercenter repository?
What is an aggregator transformation?
Explain load alternative records / rows into multiple targets - informatica
What is workflow? What are the components of workflow manager?
server hot-ws270 is connect to Repository B. What does it mean?
What are the advantages of using informatica as an etl tool over teradata?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Please let me know how to make encryption and decryption with example?
