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 8600we 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 8650Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
CTS,
6 7193Hello, 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 3698how to identify new and old values in source qualifier or any other transformations using informatica
2 4999what is rank and dense rank in informatica with any examples and give sql query for this both ranks
4 26307i 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 5987How can u insert o ne row in the target if that row does not exists in the target and update if it exists
6 12661Post New Informatica Questions
Define sessions in informatica etl?
what is index?how it can work in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is an Integration service in Informatica?
In which transformation you cannot drag ports into it?
Where do we use mapping variables in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is meant by LDAP users?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
tell me the rules and responsblites in our project(my project is development)
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Is there any target staging area in informatica not staging area
How do you update the records with or without using update strategy?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?