Answer Posted / akash

There are 2 ways through which we can achieve this:
Through informatica transformations: Source Qualifier /
Aggregator and Expression

1. Take count through an aggregator or source qualifier.
Add a port (say record_id) from sequence generator to give
the record number.
Mark router condition as -
where record_id < = (count / 2)
send this group to one target and default group of router
to other target.

2. Use the following query in Source Qualifier:
SELECT KEY_field,
description,
(CASE WHEN ROWNUM <= ((SELECT COUNT(*) FROM TEMP_TABLE)/2)
THEN 1
ELSE 2
END) AS FLAG
FROM table_name

In the above key_field and description are the required
fields from source table.

The result will be of the type:

KEY_FIELD DESCRIPTION FLAG
1 ABC 1
2 JJJ 1
3 XYZ 2
4 PQR 2

Use a router on the condition of port FLAG to map data to
targets.

What is rank transform?

1002

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1802

---

What do you mean by blocking transformation?

1051

---

What are the differences between source qualifier and joiner transformation?

1064

---

What are junk dimensions?

1076

---

Which transformation is needed while using the Cobol sources as source definitions?

1178

---

Under what condition selecting sorted input in aggregator may fail the session?

1127

---

What is complex mapping?

1127

---

How can we use mapping variables in informatica?

1067

---

explan ur project architecture?

2075

---

Performance tuning( what you did in performance tuning)

1994

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2428

---

What are the modules in Power Center

1682

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2214

---

Explain scd type 3 through mapping.

1023

---