Interested to Buy Any Domain ? << Click Here >> for more details...
How informatica process data means how informatica works?
- 2 Answers
- 13132 Views
- TCS, I also Faced
- E-Mail Answers
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 |
tell me 5 session failure in real time how can you solve that in your project?
What is the Hierarchy of DWH?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How You Pull the records on daily basis into your ETL Server.
what is parallel querying and what r hints.
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
Explain incremental aggregation in informatica
What is the fact table?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
Performance wise which is better joiner or look up ? Give me with example?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
Teradata 
