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 dynamic cache?

966

---

how we can load rejected record's at run time?(not through bad files)

2311

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

997

---

What is a predefined event?

1028

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1941

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2304

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1078

---

What are the limitations of joiner transformation?

1043

---

can anyone explain me about retail domain project in informatica?

7889

---

have u done any performance tuning? how u ll do?

2248

---

scenario where i can use only concurrent execution of workflow.

3059

---

what is SDLC way of code development?

1966

---

Is it possible to revert a global repository to local one and why?

1020

---

Explain pushdown optimization and types in informatica

1011

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2319

---