Interested to Buy Any Domain ? << Click Here >> for more details...
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
5 10630we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 9976Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
CTS,
6 9260Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
1 4430how to identify new and old values in source qualifier or any other transformations using informatica
2 6185what is rank and dense rank in informatica with any examples and give sql query for this both ranks
4 27996i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
3 7288How can u insert o ne row in the target if that row does not exists in the target and update if it exists
6 15093Post New Informatica Questions
What are the performance considerations when working with aggregator transformation?
When do you use sql override in a lookup transformation?
What is joiner transformation?
What are the different components of powercenter?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is informatica powercenter repository?
Differentiate between a repository server and a powerhouse?
How you can differentiate between connected lookup and unconnected lookup?
How we can create indexes after completing the loan process?
Explain load alternative records / rows into multiple targets - informatica
What are the types of lookup transformation?
Why update strategy and union transformations are active? Explain with examples.
How does a sorter cache works?
Explain why we use partitioning the session in informatica?
