Answer / suraj kedia

Joiner transformation is used to join source data from two
related heterogeneous sources. However this can also be used
to join data from the same source. Joiner t/r join sources
with at least one matching column. It uses a condition that
matches one or more pair of columns between the 2 sources.
To configure a Joiner t/r various settings that we do
are as below:
1)Master and detail source
2)Type of join
3)Condition of the join

What is olap (on-line analytical processing?

0 Answers  

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

---