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 7013
we 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 6827
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id firstname.lastname@example.org Thanks, Revathi.
Hello, 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 2964
what is DSS?3 3999
how to identify new and old values in source qualifier or any other transformations using informatica2 4109
what is rank and dense rank in informatica with any examples and give sql query for this both ranks4 23863
i 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 4880
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.2 4373
How can u insert o ne row in the target if that row does not exists in the target and update if it exists6 10836
Where do we use mapping variables in informatica?
What are batches?
What are the transformations that are not supported in mapplet?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can we use the mapping parameters or variables created in one mapping into another mapping?
Is it possible to revert a global repository to local one and why?
What is a connected transformation?
How will the document be delivered to me?
Differentiate between router and filter transformation?
What is the difference between informatica 7.0 and 8.0?
In informatica workflow manager, how many repositories can be created?
How to use pmcmd utility command?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a router transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? email@example.com