Answer Posted / sudhakar
it will shown single time.
ex:-in accounts dept have 10 employees.
naturally
employee dept
sai acccouts
sudhakar accounts
ramesh accounts
etc.... upto 10members
like distinct show
department show single time
Employee Dept
10 accounts
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
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
How do you handle two sessions in Informatica
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is domain and gateway node?
What is a transaction control transformation?
What is informatica etl tool?
What are the tasks that source qualifier perform?
Sequence generator, when you move from develoment to production how will you reset
What are the conditions needed to improve the performance of informatica aggregator transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is native users?
What are the transformations that are not supported in mapplet?
How to update a particular record in target with out running whole workflow?
Can informatica load heterogeneous targets from heterogeneous sources?