Answer Posted / nag

Hi,

I think this scenario will help u.
Source - SQ Trans(2 Instances)-target(2 different targets)

In one of the Instances of SQ Trans write this Query:

select distinct <field name>......from <table name>;

Note:- It fetches only unique records.

In another Source instance write the following query:

select * from <table name> where rowid not in (select max
(rowid) from <table name> group by <field name>);
ex:- select * from emp where rowid not in (select max
(rowid) from emp group by ename);

Note:- It fetches only duplicate records.

then pass the fields to the targets(u should take different
targets).

I hope this will work.

Thanks and Regards,

Nag

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1563

---

How can we remove the duplicates from flat file source?

583

---

How do you set a varible in incremental aggregation

1451

---

how many types of dimensions are available in informatica?

565

---

What is dimensional table?

623

---

---

In development project what is the process to follow for an etl developer from day1

1286

---

On which transformations you created partitions in your project?

763

---

What are the reusable transformations?

700

---

Explain the different kinds of facts.

566

---

What do you mean by enterprise data warehousing?

647

---

What are the different versions of informatica?

683

---

In informatics server which files are created during the session rums?

639

---

Performance tuning in UNIX for informatica mappings?

2145

---

What is informatica metadata and where is it stored?

591

---

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

---