Briefly explain the aggregator transformation?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

Write the unconnected lookup syntax?

0 Answers  


Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,


How do you migrate data from one environment to another?

0 Answers  


I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 Answers   Deloitte,






in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,


How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,


in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,


Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,


Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,


How can we use mapping variables in informatica? Where do we use them?

0 Answers  


what is metadata?

6 Answers  


Categories