what is distinct

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


Please Help Members By Posting Answers For Below Questions

What is the difference between informatica 7.0 and 8.0?

569


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

1539


How do you handle two sessions in Informatica

669


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

1415


What is domain and gateway node?

700






What is a transaction control transformation?

768


What is informatica etl tool?

556


What are the tasks that source qualifier perform?

633


Sequence generator, when you move from develoment to production how will you reset

1412


What are the conditions needed to improve the performance of informatica aggregator transformation?

585


complex mapping ur project u r invlve can u explain and give real time example give me ?

1845


What is native users?

725


What are the transformations that are not supported in mapplet?

602


How to update a particular record in target with out running whole workflow?

1161


Can informatica load heterogeneous targets from heterogeneous sources?

697