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 10442we 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 9842Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
CTS,
6 9041Hello, 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 4350how to identify new and old values in source qualifier or any other transformations using informatica
2 6057what is rank and dense rank in informatica with any examples and give sql query for this both ranks
4 27825i 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 7169How can u insert o ne row in the target if that row does not exists in the target and update if it exists
6 14872Post New Informatica Questions
How an expression transformation differs from aggregator transformation?
What is expression transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain the aggregator transformation?
Explain the difference between a data warehouse and a data mart?
Explain the types of transformations?
Can we create two repositories on same database instance in oracle?
What are the static cache and dynamic cache in informatica?
Write the different tools in the workflow manager?
What is an expression transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Enlist the advantages of informatica.
What are the differences between joiner transformation and source qualifier transformation?
What are active and passive transformations?
what is the difference between informatica6.1 and infomatica7.1
