Answer Posted / sanjay

1. Method

We can do it through
sq->Exp Trns->filter-->Target
!
SG

In filter trans by giving a condition "NUM=1
or NUM=5" we can get the result.

* But if you run the wf next time u need to change the NUM
value bcoz sq increments the value accrdng to the defined
condition whenever it runs the session.

2. Method
We can do it through Router trns

SQ—-Exp—Router--Target1 & Target2
!
SG
In Ist group NUM=1 & in 2nd group NUM=5.

where we'll define two groups, One for row 1 and other for
row 5.
* we need to chng the SG value every time
3. method

We can do it through parameters & variables

Describe expression transformation?

1135

---

Have you worked with/created Parameter file

1668

---

How to join three sources using joiner? Explain though mapping flow.

1151

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1276

---

How do you load only null records into target?

1220

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1089

---

What are some examples of informatica etl programs?

947

---

scenario where i can use only concurrent execution of workflow.

3180

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1983

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2257

---

Explain sql transformation in script mode examples in informatica

1141

---

What is olap (on-line analytical processing?

1074

---

What is depict expression change?

1127

---

wat are deployement groups in informatica, how it will be used for developers

1722

---

What's the layout of parameter file (what does a parameter file contain?)?

2389

---