How informatica process data means how informatica works?
Answers were Sorted based on User's Feedback
Answer / shalaka kulkarni
When work flow starts integration service retrieve mapping ,workflow ,and session form repository,It extract data from mapping sources and store in staging area apply transformation logic .then load it into target according to requirement. For that it uses three components:
Integration service process
Load balancer
DTM process
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / uday
Hi, What is the staging are here you are speaking
about...Is that on Informatica server database OR soruce
database OR target database?
| Is This Answer Correct ? | 0 Yes | 0 No |
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
why we r using presql&postsql in source qualifier?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
Can we have a Mapping without a Source Qualifier?
What is domain in terms of informatica?
Explain about Recovering sessions?
what is the use of Data Mart?
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
Explain the aggregator transformation?
Does Facttable Normalized or Denormalized?
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?