Answer Posted / pushpa

the answer number 5 for relational database objects only.
if the source is flat file we don't generate any SQL query in
the source qualifier.
then we are using the following way,
seqgen
|
sd-->sq-->expr-->filter--> td.
in the filter condition expression we take nextval<=52000.

r u done any partitions in ur project?

1827

---

Explain the code page compatibility?

1066

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1055

---

What is workflow? What are the components of the workflow manager?

1141

---

How do you update the records with or without using update strategy?

1116

---

What is the function of aggregator transformation?

1085

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2169

---

What is dimensional table? Explain the different dimensions.

1172

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1199

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

---

How can you differentiate between powercenter and power map?

1089

---

without table how to come first record only in oracle?

2253

---

what is index?how it can work in informatica

2040

---

How many numbers of sessions can one group in batches?

1064

---

Explain lookup transformation in informatica

1073

---