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 10306we 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 9748Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
CTS,
6 8864Hello, 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 4272how to identify new and old values in source qualifier or any other transformations using informatica
2 5933what is rank and dense rank in informatica with any examples and give sql query for this both ranks
4 27679i 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 7065How can u insert o ne row in the target if that row does not exists in the target and update if it exists
6 14693Post New Informatica Questions
How do you promote a non-reusable transformation to reusable transformation?
what is the difference between informatica6.1 and infomatica7.1
Can we create a Integration service without a Repository service and vice versa?
Reusable transformation and shortcut differences
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is the difference between informatics 7x and 8x and what is latest version?
What do you mean by blocking transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the different lookup cache(s)?
What is the use of target designer?
what is the hint? how to use it to reduce the query processing in program?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What could be the possible resons of locks by user?
How identifying bottlenecks in various components of informatica and resolving them?
