Answer / yaseen

After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1

Answer / spandita

After SQ expre/aggregate without selecting group by option
then it displays default last record for displaying first
record there is first function enable this then it displays
1st record.....

Answer / harish konda

First connect the exp1 with source and Sequence t/f's.

And next take the sorter and sort the data in descending
order of NEXTVAL port.

And again connect sorter to exp2 and connect sequence t/f to
this exp2.

And then connect this exp2 to router and give these
conditions NEXTVAL=1(of first sequence) and NEXTVAL=2(of
second sequence) then rout to the target.

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

What are multi-group transformations?

0 Answers   Informatica,

---

Clarify the utilization of aggregator cache record?

0 Answers  

---

How can u stop a batch?

2 Answers  

---

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

---

What is the difference between view and materialised view?

4 Answers  

---

What is meant by lookup transformation?

0 Answers  

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

---

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

0 Answers   TCS,

---

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

---